Troy,
Thanks. I thought that was the only way to do it
but I wasn't sure.
On Fri, 29 Jun 2001 08:07:30 -0600
Troy Sosamon <[EMAIL PROTECTED]> wrote:
> Bob,
>
> Is it possible to use an OUTER JOIN with more than two table/views at a
> time?
>
> Not directly. Is what you have to do is to build views that cascade with
> each other.
>
> If you want to outer join 3 tables, you build view 1 using table1 and table2
> and then build view2 using view1 and table3.
>
> Troy Sosamon
>
> ===== Original Message from [EMAIL PROTECTED] at 6/28/01 2:09 pm
> >Hello Everyone:
> >
> >I think I already know the answer to this one but I want
> >to be sure. Is it possible to use an OUTER JOIN with more
> >than two table/views at a time?
> >----------------------
> >Bob Powell
> >The Hotchkiss School
> >Lakeville, Connecticut
> >Systems Administrator
> >[EMAIL PROTECTED]
>
----------------------
Bob Powell
The Hotchkiss School
Lakeville, Connecticut
Systems Administrator
[EMAIL PROTECTED]