MySQL Forums
Forum List  »  Microsoft SQL Server

Query works in MS SQL but not in MySQL?
Posted by: Finn Jensen
Date: June 29, 2006 11:51PM

This query works fine in MS SQL but not in MySQL 4.
What is wrong?

SELECT A.table1Id, A.cdate, B.cdate2
FROM Table1 AS A
LEFT JOIN
(
SELECT table1_id, MAX(cdate) AS cdate2
FROM Table2
GROUP BY table1_id
) AS B
ON A.table1Id = B.table1_id;

/Finn Jensen

Options: ReplyQuote


Subject
Written By
Posted
Query works in MS SQL but not in MySQL?
June 29, 2006 11:51PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.