LEFT JOIN vicekrat na jednu tabulku ale dle ruznych vazebnich poli

[Martin Och]

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

--
Martin Och
Network Administrator
CS-COMPEX, a.s.

To "shut down" your system type "WIN"