Re: MultiTable Query Question

If that last table uses the same join to link to the tables above it in
the query, you'll need to create new join variables since an inclusion
join variable can only be used in the main table and the table being
joined.

or, explained a different way.. an ordinary join can be used to link three
or four tables, if necessary and convenient.. but an outer join (the
exclamation) can only link two tables.. and, more than one example can be
used in a single field, if these rules mandate it.. for example:

table A | key field |
| _joinA!, _joinB |

table B | key field |
| _joinB |

table C | key field |
| _joinB |

table D | key field |
| _joinB |

table E | key field |
| _joinA |

--
Steven Green - Waldorf Maryland USA

Diamond Software Group
http://www.diamondsg.com/main.htm
Paradox Support & Sales

Diamond Sports Gems
http://www.diamondsg.com/gemsmain.htm
Sports Memorabilia and Trading Cards
"Tony McGuire" <png.paradoxcommunity@com> wrote in message
news:4654aac0$1@xxxxxxxxxxxxxxxxxxxxxxxxxxx

then it's the join to the last table that MUST have the exclamation..
that
makes the link "whether there's a match, or not"..


If that last table uses the same join to link to the tables above it in
the query, you'll need to create new join variables since an inclusion
join variable can only be used in the main table and the table being
joined.

I reiterate this, since I messed up on this a BUNCH before I realized the
issue.



------------------------------
Tony McGuire




.

Relevant Pages

  • Re: Isotope decay chains
    ... >> if you dont know the inner momentum of a single nucleid ... > And the HUP has not yet been falsified. ... (and there i sa whole world that you cant know from that principle- so ... Superfertz (as i undesstood you suport the Superfertz as well ...
    (sci.physics)
  • Re: Damn you, FEDEX! or Nikon D40 lost in Springfield, MO blackhole.
    ... the 2 mp Mavica he had been using with a Nikon D40. ... After shopping around, he got me to order one for him. ... The shipper had it insured, but from what I have read it could take weeks to sort this crap out. ... You may get your insurance from FedEx and a couple weeks later they find it and deliver it. ...
    (alt.photography)
  • Re: The Sci-Fi Rejection Letter That Time Forgot
    ... nations have stockpiled arsenals of these incredible bombs and the time the story is set. ...
    (rec.arts.sf.written)
  • RE: copied music cds have a skip in last 18 seconds
    ... If installing all missing Windows Updates doesn't fix your problem ... xiowan.......in tucson ...
    (microsoft.public.windows.mediacenter)
Loading