I've the following SQL statement which I created in MS Access. My table
layout is the same in mySQL but it says I have an error and the query
doesn't run
SELECT AccommodationOverview.Title,
AccommodationOverview.AccommodationOverviewID,
AccommodationOverview.AccommodationID, Areas.Name
FROM AccommodationOverview INNER JOIN (AccommodationAreas INNER JOIN Areas
ON AccommodationAreas.AreasID = Areas.AreasID) ON
AccommodationOverview.AccommodationID = AccommodationAreas.AccommodationID
WHERE (((AccommodationAreas.AreasID)='58') AND
((AccommodationOverview.AccommodationOverviewID)='ENG') AND
((AccommodationOverview.AccommodationID)<>'1'))
Any ideas ?
Neil
On 7/6/06, Ed Reed <[EMAIL PROTECTED]> wrote:
Anyone have an idea on this?
Upgrade. Or at least stop repeating the question.
Jochem
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]