> >How about a normal JOIN?
>
> e.g.
>
> INSERT INTO tableA
> SELECT tableB.col1, tableB.col2, tableC.col3
> FROM tableB
> RIGHT OUTER JOIN tableC ON tableB.key = tableC.key AND <tableB

conditions>

> WHERE <other conditions>
>
> That is, provided your query is what I (thanks to Martijn) think it is.

Well, something like this - yes. :-)

I just wanted to leave that as an exercise for the reader *g*


With regards,

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