By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,027 Members | 1,261 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,027 IT Pros & Developers. It's quick & easy.

Inner Join with a MS Access module

P: n/a
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)................

Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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)................


Nov 13 '05 #2

P: n/a
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.

Nov 13 '05 #3

P: n/a

"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
Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.