SQL Join Problem
- From: "Bruce A. Julseth" <julebj_nospam@xxxxxxxxxxxxx>
- Date: Wed, 31 Dec 2008 09:54:23 -0500
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...
.
- Follow-Ups:
- Re: SQL Join Problem
- From: sheldonlg
- Re: SQL Join Problem
- From: Bruce A. Julseth
- Re: SQL Join Problem
- Prev by Date: Re: Result Sets
- Next by Date: Re: SQL Join Problem
- Previous by thread: Using uft8 encoded strings in windows filesystem
- Next by thread: Re: SQL Join Problem
- Index(es):