Re: Is this join valid?

From: roger (mothland_at_btopenworld.com)
Date: 03/05/05 

Date: Sat, 5 Mar 2005 14:34:24 +0000 (UTC)

"Ennex" <Ennex@discussions.microsoft.com> wrote in message
news:72825944-1559-499E-B71E-23AA7E425B6D@microsoft.com...

> SELECT ProductData.data2
> FROM ((ProductLines INNER JOIN LineData ON ProductLines.ID =
LineData.LineID)
> INNER JOIN Products
> ON ProductLines.ID = Products.LineID)
> INNER JOIN ProductData
> ON (Products.ID = ProductData.ProdID)
> AND (ProductLines.ID = ProductData.LineID);

> "MS Office Access can't represent the join expression
> Products.ID=ProductData.ProdID in Design view."

I think that's just one of those "features" of design view,
it's saying that it can't show you the join graphically -
not that the join won't work.

However, you may find that you can do without the
offending line, and still get the same results.

The feature I find more annoying is when the parentheses
around a subquery are changed to "[" and "]." 

-- 
roger