20.07.2016, 08:44 | #3 |
Участник
|
Цитата:
Filterednew_product_for_postavka.new_productname, Filterednew_product_for_postavka.new_quantity, Filterednew_product_for_postavka.new_configname, Filterednew_product_for_postavka.new_sizename, Filterednew_postavka.createdon, Filterednew_postavka.createdbyname, Filterednew_postavka.createdbyyominame, Filterednew_postavka.new_accountname, Filterednew_postavka.new_accountyominame, FilteredSalesOrder.ordernumber, Filterednew_product_for_postavka.new_comments, FilteredProduct.productnumber FROM FilteredProduct LEFT OUTER JOIN Filterednew_product_for_postavka ON FilteredProduct.productid = Filterednew_product_for_postavka.new_product LEFT OUTER JOIN FilteredSalesOrder RIGHT OUTER JOIN Filterednew_postavka ON FilteredSalesOrder.salesorderid = Filterednew_postavka.new_zakaz ON Filterednew_product_for_postavka.new_postavka = Filterednew_postavka.new_postavkaid WHERE (Filterednew_postavka.new_postavkaid = @PrimaryEntityId) |
|
|
|