SQLTeam.com | Weblogs | Forums

Inner Join With Select Statement


#1

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?


#2

Can you post the error message?


#3

It's just the generic syntax error. Not quite much to go from there :confused:

SQL Error (-201): A syntax error has occurred.


#4

Hmmm I think you might have to post this question on an Informix site.


#5

Ok... thanks, might as well just do that.