BAD QUERY??
Posted: Tue Sep 24, 2002 10:52 am
I'm trying to delete some data from a table, but I can't. I tried to ways but it didn'y work. What's wrong with them??
Code: Select all
DELETE FROM objetotarifaparticularidioma.* USING objetotarifaparticularidioma, objetotarifaparticular, objetotarifa, objeto WHERE objetotarifaparticularidioma.objetotarifaparticularID = objetotarifaparticular.ID AND objetotarifaparticular.objetotarifaID = objetotarifa.ID AND objetotarifa.objetoID = objeto.ID AND objeto.objetoinfoID = 1Code: Select all
DELETE FROM objetotarifaparticularidioma.* USING objetotarifaparticularidioma, objetotarifaparticular, objetotarifa, objeto WHERE objetotarifaparticularidioma.objetotarifaparticularID = objetotarifaparticular.ID AND objetotarifaparticular.objetotarifaID = objetotarifa.ID AND objetotarifa.objetoID = objeto.ID AND objeto.objetoinfoID = 1