Originally posted by ehollis
Where can I find the rules for joining tables so that I can add new information via the query?
If you're using Natural for DB2 use the JOIN option of the SELECT clause - works every time. Natural for DB2 is 100% ANSI compliant in regards to the SQL syntax.
If you're using Natural/ADABAS all you need to do is link the primary file via a similar descriptor (key) on the secondary file - data from both are available in the processing loop for either the major loop or minor loop.