Re: BIG Joins

In message Fri, 22 Jul 1994 09:50:59 +0000,   J.Caren_at_ig.co.uk (Jacqui Caren) writes:

> I think we might be talking about defferent things.
> In my email I was referring to outer joins - for a twotable outer join
> there are four cases - this requires up to four selects with unions.

There are really only three cases that you care about:

    Table1         Table2
    Exists         Exists
    Doesn't Exist  Exists
    Exists         Doesn't Exist

I don't think you really care about the fourth case:

    Table1 Table2
    Doesn't Exist Doesn't Exist

--
+--------------------------+----------------------------------------------+
| Paul Russell             | Phone:     (902) 481-3680                    |
| Software Kinetics        | Fax:       (902) 468-3679                    |
| 201 Brownlow Avenue      | Internet:  russell_at_atl.sofkin.ca             |
| Dartmouth                | "Use technology because it's appropriate...  |
| Nova Scotia, Canada      |     not just because it's cool!"             |
| B3B 1W2                  |             - E. Davidson, Software Kinetics |
 +--------------------------+----------------------------------------------+