OK, I fixed my problem by removing the JOIN keyword and just using the FROM
tblFeedback, tblMembers, tblLot WHERE tblFeedback.adsellerID =
tblMember.aduserID AND .. AND.. and that fixed the error. I am using an
Access Database only because I can not figure out how to convert one into a
sql file to be imported into mySQL. :-(
Thanks,
Kevin
Magick by Design
_____
What's the full SQL statement? Or at least a complete one with all
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
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
