Inner Join with a MS Access module

[LemonHead]

What is the syntax for an inner join when writing a inner join within a
module ? I can not figure out why on some modules I see people using
a parenthesis when writing an inner join ? See example below.

"From (tblorders INNER JOIN ztblPrices ON " & _
"tblOrders.PriceID = ztblPrices.PriceID) INNER " & _
"JOIN ztblProducts ON ztblPrices.ProductID = " & _
"ztblProducts.ProductID)................

[Tom van Stiphout]

On 23 Apr 2005 18:30:28 -0700, "LemonHead" <po********@gmail.com>
wrote:

The syntax is documented in the help file.
But I would rather use the query designer to create my query, and then
switch to SQL view to inspect the SQL statement.

-Tom.

What is the syntax for an inner join when writing a inner join within a
module ? I can not figure out why on some modules I see people using
a parenthesis when writing an inner join ? See example below.

"From (tblorders INNER JOIN ztblPrices ON " & _
"tblOrders.PriceID = ztblPrices.PriceID) INNER " & _
"JOIN ztblProducts ON ztblPrices.ProductID = " & _
"ztblProducts.ProductID)................

[LemonHead]

I also build in the query designer and then switch to the SQL viewer,
but if you dump this into a module the syntax needs to be changed. I
am primarily trying to detrmine the parenthesis.

[Rick Brandt]

"LemonHead" <po********@gmail.com> wrote in message
news:11**********************@g14g2000cwa.googlegr oups.com...

I also build in the query designer and then switch to the SQL viewer,
but if you dump this into a module the syntax needs to be changed.

Why? That is not my experience. The only difference I see in SQL in-code is
that you can't include form references in the statement, but you can take those
out of the quoted area to get the value.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com