SQL Join Problem



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...


.