Delete - zvlastny problem

[Miroslav Oravec]

Prajem prijemny den,

neviem vyriesit tento problem:
(pouzivam MySQL ver. 3.23.36)

Mam tabulku "A" so stlpcom id o obsahu {1,2,3,4,5,6,7,8,9}
a tabulku "B" so stlpcom id o obsahu {3,4,5}.
Je zrejme, ze v tabulke B su voci tabulke A duplicitne zaznamy.

Chcem z tabulky A zmazat tie zaznamy, ktore sa nachadzaju aj v tabulke
B.

Takze som si myslel, ze SQL dotaz bude:

delete from A where A.id = B.id

Vyhlasuje chybu: 1109- Unknown table 'B' in where cause

Upravim zaznam na:

delete from A, B where A.id = B.id

a vyhlasi chybu: 1064 - You have an error in your SQL syntax near 'B
where A.id = B.id' in line 1.

Takze som skusil:

delete A.* from A, B where A.id = B.id

a hlasi chybu: 1064 - You have an error in your SQL syntax near 'A.*
from A, B where A.id = B.id' in line 1.

A tak si neviem rady.
Ako na to?

S pozdravom
mior