Апельсин
Оранжевое создание
жена ..
Список рассылки MySQL. Диалог.
>>I have two tables (identical structure) and want to get the rows from
>>table1 that not exists in table2 based on a my_id column.
>>Is it correct to write it as:
>>SELECT DISTINCT table1.* FROM table1
>> LEFT JOIN table2 ON table1.my_id = table2.my_id
>> WHERE table2.my_id IS NULL
> Looks OK to me.
> What problem did you have when you tried it?
Thanks for the answer.
I really didn't have any problems with it but my dear wife didn't trust
the result :-( Therefor I went unsure.
Список рассылки MySQL. Диалог.
>>I have two tables (identical structure) and want to get the rows from
>>table1 that not exists in table2 based on a my_id column.
>>Is it correct to write it as:
>>SELECT DISTINCT table1.* FROM table1
>> LEFT JOIN table2 ON table1.my_id = table2.my_id
>> WHERE table2.my_id IS NULL
> Looks OK to me.
> What problem did you have when you tried it?
Thanks for the answer.
I really didn't have any problems with it but my dear wife didn't trust
the result :-( Therefor I went unsure.
