19.04.2007, 13:32 | #1 |
SAP
|
Join в Query
Недавно столкнулся с такой ситуацией:
X++: static void Asch_Job16(Args _args) { SalesTable salesTable; SalesLine salesLineFirst; SalesLine salesLineSecond; ; select salesLineFirst // qbds1 where salesLineFirst.SalesId == "Номер заказа" // qr1 notexists join salesTable // qbds2 where salesTable.CustAccount == "Клиент" // qr2 join salesLineSecond // qbds3 where salesLineSecond.SalesId == salesTable.SalesId // qr3 && salesLineSecond.ItemId == salesLineFirst.ItemId // qr4 && salesLineSecond.SalesPrice == salesLineFirst.SalesPrice; // qr5 } |
|