Hi,

How about a normal JOIN?


With regards,

Martijn Tonies
Database Workbench - the developer tool for InterBase & Firebird
Upscene Productions
http://www.upscene.com

> 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?