|
I have this SQL statement: SELECT * FROM DBPOPOR EXCEPTION JOIN DBPOPRL ON DBPOR_COMPANY = DBPRL_COMPANY AND DBPOR_REC_NUMBER = DBPRL_REC_NUMBER ORDER BY DBPOR_COMPANY, DBPOR_REC_NUMBER I would like to delete all records that come up. But obiously I can't just do: DELETE FROM DBPOPOR EXCEPTION JOIN DBPOPRL ON DBPOR_COMPANY = DBPRL_COMPANY AND DBPOR_REC_NUMBER = DBPRL_REC_NUMBER ORDER BY DBPOR_COMPANY, DBPOR_REC_NUMBER Is there a simple way to set this up or do I have to do this the hard way? -- Mike Wills iSeries Programmer/Lawson Administrator koldark@xxxxxxxxx http://www.koldark.net Want Gmail? Email koldark+gmail@xxxxxxxxx to get on my waiting list.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
