Попробуйте такое:
Код:
SELECT Filterednew_postavka.new_name, Filterednew_postavka.new_skladname, Filterednew_postavka.new_ts_typename, Filterednew_postavka.new_zakazname,
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 and FilteredProduct.ProductNumber like 'ГП%'