Delete from 2 table

wxdqz

New Member
I have a problem i want to delete a data from 2 table. For the example..it's like this
for Db1

ItemID Name Age

Db2

ItemID Class

I try to using this command

Delete from Db1,Db2 where Itemid='$id' Or
Db1.ItemID = Db2.ItemID
but it give an error with

it said that the clause is ambiguous
 
Back
Top