I need to create a query on a file that has several detail lines for the same shipper number, I would like to see only one line per shipper number, using SQL I get the result I want by using the following command --- SELECT DISTINCT compny, shpinv, acode, cabbv, dabbv, shipdt, oem
FROM futdtalib/vlpasn WHERE acode = 'I'
How can I get the same results using Query so that I can schedule a job to run nightly and create a report.
Any help would be appreciated. I have been away from the 400 for a while :)