Re: newbee question

On Fri, 23 Jul 2004 11:53:13 -0400, P B <pbeliveau_at_avior.ca> wrote:

>But: there is no relation between item (table 2) and account (table 3)
>since one item may affect multiple account and multiple item may
>affect the same account. Table 3 is the summary of the affected
>account for an invoice.

so there is a relationship between table 1 and table 3. The remark about the cartesian product and missing where clauses holds

--
Sybrand Bakker, Senior Oracle DBA