Re: what's wrong with this query?

sorry to waste your time read.. less than 60 seconds after posting, I found another site which explain what the problem was. My new (working) query is:

INSERT INTO table_nameA
(person_id,object_id,person_type,show_profile)  SELECT 120,137,1,0 FROM dual WHERE NOT EXISTS (   SELECT *
  FROM table_nameA
  WHERE person_id = 120 AND object_id = 137 )

It was the "dual" part that I didn't understand, but now I do. Received on Thu Jan 26 2006 - 14:01:51 CST