PDA

Click to See Complete Forum and Search --> : join four tables

milos
10-06-2006, 04:24 PM
I need to join four tables, and select only one field in each one. Field has the same name in all four tables.
chazzy
10-06-2006, 04:33 PM
Ok..?
What are you stuck on though?
CCCP
10-06-2006, 04:36 PM
I need to join four tables, and select only one field in each one. Field has the same name in all four tables.
SELECT A.mycolumn, B.mycolumn, C.mycolumn, D.mycolumn
FROM mytable_no_1 A,
mytable_no_2 B,
mytable_no_3 C,
mytable_no_4 D,
WHERE A.xxx = B.xxx
AND A.xxx = C.abc
AND C.xxx = D.yyy
milos
10-06-2006, 04:42 PM
what does A.xxx= B.xxx means?