SELECT * FROM proddta.F4111 WHERE ildgl >= 111274 AND
ildgl <= 111304 AND
ildct = 'RI' AND
ildcto IN ('S7','S9','SA','SE','SF','SH','SJ','SN','SQ','ST','SU','SV','SW','SX','V1','V2','V4','V7','V8','V9','VA','VF','VJ','VM','VN','VQ','VR','VS','VT','VU','VV','VX','VY') AND
NOT EXISTS (SELECT * FROM proddta.F554113 WHERE raukid = ilukid)
No comments:
Post a Comment