I've converting a database from a M$Access to mySQL - which I've done and it works fine. However now I've got the databases done, I've found bits of the SQl don't work!
Example...
SELECT
EventType.Name AS EvtName,
Events.NextEventDate,
Events.EventTypeID,
Events.Public,
Reminder.RecordID AS RemID,
Reminder.RemindForName,
Relationships.Type,
Reminder.UserID
FROM
(Reminder LEFT JOIN Relationships ON Reminder.RemindForRelID = Relationships.RecordID) INNER JOIN (Events LEFT JOIN EventType ON Events.EventTypeID = EventType.RecordID) ON Reminder.EventID = Events.RecordID WHERE UserID = 27
Now I know that mySQL can't deal with Sub-Selects, but this isn't one is it? I didn't write the code originally, and I'm not hot on SQl but learning :0 Any help would be most appretiated...
Example...
SELECT
EventType.Name AS EvtName,
Events.NextEventDate,
Events.EventTypeID,
Events.Public,
Reminder.RecordID AS RemID,
Reminder.RemindForName,
Relationships.Type,
Reminder.UserID
FROM
(Reminder LEFT JOIN Relationships ON Reminder.RemindForRelID = Relationships.RecordID) INNER JOIN (Events LEFT JOIN EventType ON Events.EventTypeID = EventType.RecordID) ON Reminder.EventID = Events.RecordID WHERE UserID = 27
Now I know that mySQL can't deal with Sub-Selects, but this isn't one is it? I didn't write the code originally, and I'm not hot on SQl but learning :0 Any help would be most appretiated...