Пятница, 20 Июня 2014 г. 14:42
+ в цитатник
Добрый день.
Кто поможет поправить меня со скобками?
SELECT DISTINCT *
FROM tbl_ref_KAListing RIGHT OUTER JOIN
(((tbl_ref_KAListing AS tbl_ref_KAListing_1)
RIGHT OUTER JOIN
(vw_DeclarationScanCopies
RIGHT OUTER JOIN vw_Materials_Declarations_Latest ON vw_DeclarationScanCopies.DclNum = vw_Materials_Declarations_Latest.DclNum)
(((((RIGHT OUTER JOIN vw_Material_wt_KA ON vw_Materials_Declarations_Latest.MCode = vw_Material_wt_KA.MCode)
LEFT OUTER JOIN
vw_BOM_withNames AS vwGPs) ON vw_Material_wt_KA.MCode = vwGPs.GP_MCode)
LEFT OUTER JOIN
(SELECT MCode
FROM vw_PriceList_UA_Today
WHERE (PL_TypeId = 1) AND (IsInLatestPL = 1)
) AS vw_InPLRetail ON vw_Material_wt_KA.MCode = vw_InPLRetail.MCode)
LEFT OUTER JOIN
(SELECT MCode
FROM vw_PriceList_UA_Today AS vw_PriceList_UA_Today_1
WHERE (PL_TypeId = 2) AND (IsInLatestPL = 1)
) AS vw_InPLFS ON vw_Material_wt_KA.MCode = vw_InPLFS.MCode)
LEFT OUTER JOIN
vw_PriceList_Actual_ExportBY ON vw_Material_wt_KA.MCode = vw_PriceList_Actual_ExportBY.MCode ON
tbl_ref_KAListing_1.UL_MCode = vw_Material_wt_KA.MCode AND tbl_ref_KAListing_1.KAId = 2 ON
tbl_ref_KAListing.UL_MCode = vw_Material_wt_KA.MCode AND tbl_ref_KAListing.KAId = 1)
LEFT OUTER JOIN
vw_BOM_withNames ON vw_Material_wt_KA.MCode = vw_BOM_withNames.Compon_MCode AND
vw_BOM_withNames.GP_Status <> 4)
LEFT OUTER JOIN
(vw_CertificateScanCopies
RIGHT OUTER JOIN
vw_Materials_Certificates_Latest ON vw_CertificateScanCopies.CertNum = vw_Materials_Certificates_Latest.CertNum) ON
vw_Material_wt_KA.MCode = vw_Materials_Certificates_Latest.MCode)
LEFT OUTER JOIN
(vw_HygieneScanCopies
RIGHT OUTER JOIN
vw_Materials_Hygienes_Latest ON vw_HygieneScanCopies.HygNum = vw_Materials_Hygienes_Latest.HygNum) ON
vw_Material_wt_KA.MCode = vw_Materials_Hygienes_Latest.MCode)
WHERE ( vw_Material_wt_KA.StatusName <> 'Delisted') AND ( vw_Material_wt_KA.A1 <> 'PK')
http://www.sql.ru/forum/1101297/skobki
-
Запись понравилась
-
0
Процитировали
-
0
Сохранили
-