posted 12 years ago
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.