andrei(dot)ivanov(at)ines(dot)ro says...
> I'm planning to something like
> INSERT INTO first_table
> SELECT * FROM second_table s WHERE
> NOT EXISTS (SELECT 1 FROM first_table WHERE id = s.id)
What about
INSERT INTO first_table T1
(SELECT * FROM second_table T2 WHERE myValue
NOT IN (SELECT myValue FROM T1 WHERE T1.id = T2.id))
Something like that?
Paul...
--
plinehan__AT__yahoo__DOT__com
C++ Builder 5 SP1, Interbase 6.0.1.6 IBX 5.04 W2K Pro
Please do not top-post.