Skip to navigation
Nested mssql select as a where condition
03.03.17
example: SELECT y.[yz3_style] AS style111 ,y.[yz3_qty] ,b.F21_av0_section ,b.av0_metal FROM [SL].[dbo].[yz3_stock] AS y LEFT JOIN av0_style AS b ON b.av0_style = y.yz3_style WHERE y.yz3_location in (1,11) AND y.yz3_qty > 0 AND b.F21_av0_section IN ('RG','PD','EAR','CHM','BRA','NKL','TOR') AND b.av0_metal IN ('GPS','GPL','RGL','RGS','SUS') and (select top 1 x.yz3_qty from [SL].[dbo].[yz3_stock] AS x where yz3_location = 9 AND y.yz3_style = x.yz3_style AND x.yz3_qty > 0) IS NULL
https://msdn.microsoft.com/en-us/library/ms188047.aspx
Reply
Anonymous
Information Epoch 1714526396
When in doubt, use brute force.
Home
Notebook
Contact us