Re: Multi Table View

From: Thierry PLASSART <thierry.plassart_at_wanadoo.fr>
Date: Sun, 13 Mar 2005 19:11:02 +0100
Message-ID: <42348217$0$19312$8fcfb975@news.wanadoo.fr>

Hi,

just try an outer join between table1 and table3

table1.salesid (+) = table3.salesid (or the other way...)

"Mitchell" <mithomas_at_boh.com> a écrit dans le message de news:1110599266.954976.68230_at_g14g2000cwa.googlegroups.com...
> I am creating a multi-table view. Table1 joined to Table2 by ID field,
> it is a one to one match, also I want to join table3 to table1 by
> SALESID, but not all records in Table1 will have a matching record in
> Table3, but I want to return all records in Table1. I am a little
> confused on the Union Select statement when you have 3 tables. Any
> help with the correct syntax would be greatly appreciated?
>
> Thankx,
>
> Mitchell,
>
Received on Sun Mar 13 2005 - 12:11:02 CST