LEFT JOIN vicekrat na jednu tabulku ale dle ruznych vazebnich poli

[Honza Pazdziora]

On Tue, Dec 14, 1999 at 09:41:38AM +0100, Martin Och wrote:
> Dobry den.
> 
> Marne premyslim jak napsat neco takoveho:
> 
> select pole2.table1, pole2.table2, pole2.table3, pole2.table4 from table1
> left join table2 on pole5.table1=pole1.table2
> left join table3 on pole6.table1=pole1.table3
> left join table4 on pole7.table1=pole1.table4
> 
> POZOR table2=table3=table4 - JEDNA TABULKA
> 
> Nevim, jestli je to takhle srozumitelne.
> Hlavni tabulka table1 obsahuje vazebni pole pole5-7 na tabulku table2
> 
> Dekuji za Vase namety

Pouzit aliasy?

	left join table2 table3 on pole6.table1=pole1.table3

nebo

	left join table2 as table3 on pole6.table1=pole1.table3

nebo jak je konkretni syntaxe konkretniho serveru.

------------------------------------------------------------------------
 Honza Pazdziora | adelton na fi.muni.cz | http://www.fi.muni.cz/~adelton/
   .project: Perl, DBI, Oracle, MySQL, auth. WWW servers, MTB, Spain.
------------------------------------------------------------------------