Hi,
I'm trying to do an INNER JOIN in MySQL (3.23.39 - Linux i686) that works
perfectly when I test it in Access but MySQL is complaining and the web docs
seem to suggest I'm doing it right. Can anyone see the error? I've got
indexes on both tables on the joined field (Primary for AttractionInfo and
just an index for AttractionType).
Here is the query:
SELECT AttractionInfo.AttractionID, AttractionInfo.AttractionName,
AttractionInfo.ShortDesc, AttractionInfo.Community FROM AttractionInfo INNER
JOIN AttractionType ON AttractionInfo.AttractionID =
AttractionType.AttractionID;
MySQL said: You have an error in your SQL syntax near 'ON
AttractionInfo.AttractionID = AttractionType.AttractionID;'
Any ideas?
Thanks.
Bob.
Bob Horton
PneumaSoft Services Inc.
Custom Software & Web Development
Phone: (306) 545-1068
[EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
