DELETE from table

[jfielding2000]

if I had tblOrders OrderNo, CustomerNo, Date, OrderTotal
tblCustomers CustomerNo, Name, Street, Country, Postcode

and I was asked to delete orders placed by customer Smith, would I be correct if I put this:

DELETE tblOrders*
FROM tblOrders INNER JOIN tblCustomers ON tblOrders.CustomerNo = tblCustomers.CustomerNo
WHERE Name = "Smith"


I wasnt sure about the DELETE tblOrders to have a '*' after it or not . .

 

[georgedwilkinson]

Did you try it in the visual query designer?

You should probably put a "." between the table name and the "*".

 

[jfielding2000]

ok thanks for the advice!

 

[GaryPanic]

this would delete all smith orders -- are you sure - might be better to delete by order no - and run a qry for smith and order numbers