Re: SQL Join Problem

Bruce A. Julseth wrote:
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,

Yes.


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


.

Relevant Pages

  • Re: Can you decrypt this?
    ... Khalid to separate it. ... Bruce, have a managing break. ... Anthony, for nightmares abstract and strict, closes ...
    (sci.crypt)
  • Re: question.. not sure where to post..!!
    ... >basically, i'm considering what might be used as a dual server, where i can ... >spread the work load not run two separate systems in one box. ... >>Bruce Douglas ... So buy 2 computers and glue them together. ...
    (RedHat)
  • Re: PHP code not displaying in IE 6
    ... Bruce A. Julseth wrote: ... >Test Line 1 displays fine by not the PHP line. ... might try a workaround by getting and installing a copy of Apache, ...
    (comp.lang.php)
  • Re: message rules news
    ... Thank you Bruce. ... newsgroup in particular has a lot of porn ads and they are usually followed ... I would make separate rules ... > Some Message Rule Ideas: ...
    (microsoft.public.windows.inetexplorer.ie6_outlookexpress)
  • Re: Forwarding mail with attachments - replicating &/or separating
    ... OH MY GOSH, Bruce, just that easy!! ... attachments appear to separate as individual emails & arrive garbled - & ...
    (microsoft.public.windows.inetexplorer.ie6_outlookexpress)