the parts. Also, by using just "JOIN" in your statement, you're
getting a full join, which can be very inefficient. Much better to do
a LEFT JOIN or an INNER JOIN if at all possible. Depending on your
database, you may have to explicitly group the joins with parentheses:
from ( t1 JOIN t2 ON t1.col1 = t2.col1) JOIN t3 ON t2.col2 = t3.col2
cheers,
barneyb
On Fri, 27 Aug 2004 22:37:39 -0400, Kevin <[EMAIL PROTECTED]> wrote:
> Hi all,
>
> I am getting a SQL error when I use two JOIN statements in my query. Can
> anyone tell me the syntax to use multiple JOIN statements?
>
> Here is an example:
>
> FROM tblMember JOIN tblFeedback ON tblMember.aduserID =
> tblFeedback.adsellerID
>
> JOIN tblLot ON tblFeedback.adlotID = tblLot.adlotID
>
> I have narrowed the error to somewhere in this code. But after that I am
> stuck.
>
> Thanks,
>
> Kevin
--
Barney Boisvert
[EMAIL PROTECTED]
360.319.6145
http://www.barneyb.com
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
