Thanx for ur prompt response.
But after knowing this I don't know how to convert one of my complex queries in Oracle to run it in Firebird. The embedded query doesn't seems to be applicable here. Can u give me a li'le guidance for that.

My query is like this :
INSERT INTO tableA
SELECT colA, colB, colC
FROM ( SELECT col1 as colA, col2 as colB
FROM tableB
WHERE <condition>
) RIGHT OUTER JOIN
( SELECT col3 as colC
FROM tableC
WHERE <condition>
) ON tableB.key = tableC.key
WHERE <condition>

Can u plz. give me some hint, how can I convert these queries to run it into Firebird?

Thanx once a'ain.
Meghansh.




---------------------------------
Yahoo! Plus - For a better Internet experience


[Non-text portions of this message have been removed]