Hello everyone.
I'm new to this forum, so I'm pretty sure I'm doing something wrong here lol...
Anyway, I'm having a problem regarding an SQL statement that I use very commonly on SQL Server Studio Management, but it gives me an SQL error on Informix platform.
Here's an exemple of the SQL statement:
SELECT *
FROM t1 AS tEx1
INNER JOIN (SELECT order_num,
MAX(date) AS modate
FROM t2
GROUP BY order_num) AS tEx2
ON tEx1.order_num = tEx2.order_num
AND tEx1.date = tEx2.modate
Am I missing something for the Informix platform? Any clues?