Re: Please Help with outer join syntax...
On Fri, 20 Aug 1999, Steven Wong wrote:
> How would one write an outer join query that does the following:
>
> Four Tables A, B, C, D.
>
> A left joins to B
> B left joins to C
> B left joins to D
>
> Thanks for your feedback!
>
> Steve
>
>
>
select col_name
from A, outer (B, outer C, outer D)
where A.join_column = B.join_column
and B.join_column = C.join_column
and B.join_column = D.join_column
Have fun.
====================================================================
Harold Luse Phone: (970) 491-4120
Veterinary Teaching Hospital Fax: (970) 491-4123
Colorado State University Pager: (970) 229-8173
Fort Collins, Colorado USA E-mail: hluse@vth.colostate.edu
====================================================================