Avatar of Mick_Buckley

asked on 

Deleting records

Hi i would like to delete some records out of a table, the following query gets the records i would like to delete
Select * from [RecognitionsTest]
right join [recognitions-original] on RecognitionsTest.TimeStamp = [Recognitions-original].timestamp and RecognitionsTest.Plate = [Recognitions-original].plate

The records i want deleting are from the recognitions table only I'm not quite sure of the syntax to delete these records

Thanks Mick
Microsoft SQL Server 2005SQL

Avatar of undefined
Last Comment

8/22/2022 - Mon