Delete by Using INNER JOIN SQL Server

Delete by Using INNER JOIN SQL Server


select * from CDR_0(nolock) a inner join CDR_Aug11(nolock) b on a.MSISDN = b.MSISDN
where (a.file_id=1526046) and a.b_number = b.b_number and a.charging_timestamp = b.charging_timestamp




Delete a from CDR_0(nolock) a inner join CDR_Aug11(nolock) b on a.MSISDN = b.MSISDN
where (a.file_id=1526046) and a.b_number = b.b_number and a.charging_timestamp = b.charging_timestamp