At 13:23 15.07.2003 +0200, you wrote:

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

HTH,
Set