say I'm selecting distinct (non-duplicate) rows for insertion,

insert into original_table select distinct * from new_table

these tables have 3  fields/row. Per the above code all 3 fields are 
evaluated by "distict *" .

But my question is: I want to ignore field1, therefore I only want to 
test if any rows have field2 *and* field3 as dups - that would be my 
distinct test and then do the insert based on that. Test f2 and f3, not
f1.

What the sql? Help is greatly appreciated.

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to