i am trying to insert data from multiple tables using this query but keep getting ORA -SQL Error: ORA-00913: too many values. What I am trying to do is basically insert data into target table from source table but only if the new data is not already in the target table.
INSERT INTO target_table A
(a.target_tableI_NUMBER,target_table.ID, a._NAME)
SELECT s.NUMBER,a.ID,sID, s.NAME FROM Source_table s , target_tableI a
WHERE EXISTS (SELECT 1 FROM Source_table s WHERE s._ID = a.ID);