Dear all,

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.



Regards Benny