delete sql not working

[bhavin ragha]

trying to delete all information relating to cd005

im putting in the statement below. But i get the error: near ",": syntax error... (im using sqlite)

delete from cds, bands, band_members, releases
where band_members.band_id = bands.band_id
and band_members.band_id = releases.band_id
and cds.cd_id = releases.cd_id
and cds.cd_id = 'cd005'

when i change delete to select * i get the values that i want to delete.

[Paul Clapham]

You can only delete rows from one table using the SQL DELETE statement.

[bhavin ragha]

Paul Clapham wrote:You can only delete rows from one table using the SQL DELETE statement.

so how do i delete all data relating to cd005

[Bear Bibeault]

One table at a time.

[Saurabh Pillai]

Or if you are allowed to set cascade delete option.