compare records between parent and child table
Posted: Tue May 26, 2009 5:00 pm
i want to compare the records in the parent table and the child table and to find out the uncommon record between them.
i have a SQL query for this ,but every time i have to change it manually depending upon the foreign key relation(constraint).
Please suggest if it can be done using rexx in a more simpler way.
i have a SQL query for this ,but every time i have to change it manually depending upon the foreign key relation(constraint).
Please suggest if it can be done using rexx in a more simpler way.