 |
 |
Archives of the TeradataForum
Message Posted: Fri, 30 Jul 2004 @ 12:57:04 GMT
| Subj: | | Re: Inner joins and missing data |
| |
| From: | | Anomy Anom |
<-- Anonymously Posted: Friday, July 30, 2004 08:54 -->
Determine which table will drive the process (always have data), then use OUTER joins to the other tables. Depending on the relationships
between the tables, you may end up needing to slap a coalesce statement in the select to ensure proper data presentation (especially if you don't
have a "true" driver table..
| |
