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
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