jeudi 15 janvier 2015

SQlite delete inner join

I have read alot of other answers but cannot get this working!.



select * from invTypes
inner join invGroups on invtypes.groupID = invgroups.groupID
where invGroups.categoryID = 25;


I simply want to delete the record from invTypes if the category ID matches to 25


Would be very grateful of assistance


Aucun commentaire:

Enregistrer un commentaire