
September 3rd, 1999, 10:40 PM
|
|
Guest
|
|
Posts: n/a
Time spent in forums:
Reputation Power:
|
|
|
Ok, I'm still lost with JOINs. I have several sub-tables which I want to comglomerate with my main table. For example, let's say I have a table like this:
ID Widget1 Widget2
------------------
1 1 2
2 3 4
and another table like this:
ID Description
--------------
1 Widget1
2 Widget2
3 Widget3
4 Widget4
I want to be able to end up with a table like this:
ID Widget1 Widget2
------------------
1 Widget1 Widget2
2 Widget3 Widget4
I can get a one column version of this working by doing something like this:
SELECT tblWidgets.DESCRIPTION FROM tblItems LEFT JOIN tblWidgets ON tblItems.Widget1=tblWidgets.ID
but I can't get it to work for two or more items. Do I need to use 2 seperate select statements? I have tables where I have 4 or 5 of these situations...it seems like one statement would be very cumbersome.
dazed and confused. :-) Thanks!
|