convert query to query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My delete query is asking "which table to delete records from?"

I used the asterick of the table from which I want the records deleted.

Can't figure it out.
 
My delete query is asking "which table to delete records from?"

I used the asterick of the table from which I want the records deleted.

Can't figure it out.
Click to expand...

Well, we can't either... *you* can see the query; we cannot.

Care to open the query in SQL view and post it here?

Just a GUESS: the table from which you wish to delete records should
be the only table mentioned in the DELETE clause, as in

DELETE TableA.*
FROM TableA Inner Join TableB
ON TableA.ID = TableB.ID
WHERE TableB.Action = "Delete Me";

rather than

DELETE TableA.*,TableB.Action
FROM...

John W. Vinson[MVP]
 
Back
Top