Re: SQL Join Problem


"Bruce A. Julseth" <julebj_nospam@xxxxxxxxxxxxx> wrote in message
news:3FL6l.700$fE1.500@xxxxxxxxxxxxxxxxxxxxxxxxx
I have Table "Main" that has 3 foreign keys which point to Tables "A", "B"
and "C". Table "B" has a foreign key pointing to Table "D".

I have no problem creating a Join for Tables A, B and C. My question is,
is it possible to include "D" in this Join, or do I need to do a separate
Select to D after getting the Key Value from the main Join? This is the
only way I can figure out how to do it, but I'm hoping that someone out
there in Genius land can suggest a better way.

Thanks...


Never mind. I "Think" I have figured it out. Need to do some more testing
but what I have seems to work, namely I just added to the Join the access to
the value in table D that I want.

Thanks...


.