Delete FROM
Filea left join FileB on
Filea.field1 = Fileb.file1 and
Filea.field1 = Fileb.file2 and
Filea.field1 = Fileb.file3
where
Fileb.file1 is null
Any way how to optimaze this statment?
I want to delete the record that exist in FileA that dosen't existe in FileB
Filea left join FileB on
Filea.field1 = Fileb.file1 and
Filea.field1 = Fileb.file2 and
Filea.field1 = Fileb.file3
where
Fileb.file1 is null
Any way how to optimaze this statment?
I want to delete the record that exist in FileA that dosen't existe in FileB
Comment