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]