How to delete items

[elmo25]

Hello,
May i ask is the any way to delete items that had related to three tables.
This is because if i need to delete the items i need to delete all in the three tables that had related to it.
This is what i wrote but have error.
delete from table1,table2,table3 where table1.itemA=table2.itemA and table2.itemB=table3.itemB and expiredate= 20050101;

table1:
itemA

table2:
itemA
itemB

table3:
itemB
expiredate

please help me to correct it.

thanks.

[laserlight]

What's your database schema like?

It could well be that a re-design might be in order.

[Roger_Ramjet]

It is also version specific.

from the manual

From MySQL 4.0, you can specify multiple tables in the DELETE statement to delete rows from one or more tables depending on a particular condition in multiple tables. However, you cannot use ORDER BY or LIMIT in a multiple-table DELETE.

[elmo25]

CREATE TABLE FLASH
(
ID_FLASH int(8) NOT NULL AUTO_INCREMENT PRIMARY KEY,
DURATION int(3),
REPLAY int(1) NOT NULL,
PERIOD int(3) NOT NULL,
TOTAL_DURATION int(4) NOT NULL,
RECEIVE_DATE TIMESTAMP(8)
);

CREATE TABLE AD_INFO
(
FILE_NAME varchar(10) PRIMARY KEY NOT NULL,
ID_FLASH int(8) REFERENCES ADVERTISEMENTS(ID_ADVERTISEMENT),
FLASH_NAME varchar(30),
START_DATE TIMESTAMP(8),
TOTAL_SLOT int(1) NOT NULL
);

CREATE TABLE DISPLAYMODE
(
FILE_NAME varchar(10) NOT NULL,
SLOT int(2) NOT NULL,
END_DATE TIMESTAMP(8),
PRIMARY KEY(FILE_NAME, SLOT)
);

i need to delete the flash when give a time that bigger than the END_DATE.

thanks