Hi,

> I'm new in FireBird, I have an Oracle syntax :
>
> SELECT C.* FROM
> (SELECT DISTINCT A.ID, A.TYPE, B.START_DATE FROM CAMPAIGN A
> LEFT JOIN CAMAPIGN_DELIVER B
> ON A.ID = B.ID
> WHERE A.USER_NAME = 'Benny') C
>
>
> I have a problem with that SQL syntax on FireBird.

Actually, it's Firebird who has a problem with your syntax.

What's wong with using:

SELECT DISTINCT A.ID, A.TYPE, B.START_DATE FROM CAMPAIGN A
LEFT JOIN CAMAPIGN_DELIVER B
ON A.ID = B.ID
WHERE A.USER_NAME = 'Benny'


Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
http://www.interbaseworkbench.com

Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."