query pb????

[Anonymous]

For your first question is - in my opinion - the best solution to select all with a distinct on the condistions you need to use. Put the result in a temporary table. Truncate the originale table and insert de data again from the temporary table.

Second question, possible solution: (mysql 4.0 needed)

SELECT *
FROM   table1
WHERE ( a, b, c ) NOT IN ( SELECT a, b, c
                        FROM   table2 );