iseries SQL Find missing child or parent with NOT EXISTS

Example

SELECT sdfcabn.stcuno FROM sdfcabn WHERE not exists (select * from

cufship where cufship.stcuno = sdfcabn.stcuno)

This entry was posted on 17. October 2011 at 20:35 and is filed under SQL. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response or trackback from your own site.