Skip to content

Instantly share code, notes, and snippets.

@trplll

trplll/shipmentwoload.sql

Created November 22, 2016 15:01
Show Gist options
  • Save trplll/5e65427d420c0753d24a6958fbcd05da to your computer and use it in GitHub Desktop.
Save trplll/5e65427d420c0753d24a6958fbcd05da to your computer and use it in GitHub Desktop.
Download ZIP
Shipments without load basic query
Raw
shipmentwoload.sql
SELECT sddoco,sdlnid,sdmcu,sdshan,RSSHPN, RSLDNM, RSPPDJ FROM F4211
join F4941 on sdshpn=rsshpn
WHERE SDNXTR>=535
AND SDNXTR<=550
AND SDPPDJ>=115326
and RSLDNM=0
AND RSPPDJ>115326
and sdmcu in (' 20')
and sdshan in (' 22',' 24',' 25',' 27',' 28')
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment