How can i select a lot of tables in order to do the same command?

For example, i wan to delete a data from 3 tables. The data i wan to delete haf an ID which all the tables haf.
So how to select them all.

Normally we use

Select *
From Table1 Where ............

How aboyt now???

I think this works:

SELECT * FROM table1, table2, table3 WHERE ....

HTH,

Snib

<><

Should be something like this, as I am not sure about what tables you have and from which table the records are to be deleted.

Select A.*
from TableForDelete A, TableRef1 as B, TableRef2 as C
Where A.IDField=B.IDField and A.IDField=C.IDField

The where clause might change depending on the relationship between the tables that are involved.

Hope that helps.
Cheers!

-Vijay G

Yeah....
Tats help.
i settle the problem.
Thaks