I have a select query (was easier to show it that way) but i would like to be able to delete these rows from TblWordTags but I dont know how to construct the delete query.
I would like to create a stored procedure and pass the variables of [word] (in this case 'BM') and also the [vehCategory] in this case 'Motorcycle'
I have to take the vehcategory into account.
If you need me to write down the columns etc then let me know, I havnt found a quick way to do that yet.
SELECT TblWords.ClientCodeWordPosition,TblWords.ClientCode, TblWords.Word, [TblVehCat].ClientCode, TblVehCat.VehCategory
FROM TblWords LEFT JOIN TblWordTags ON TblWords.ClientCodeWordPosition = TblWordTags.ClientCodeWordPosition LEFT JOIN [TblVehCat] ON [TblWords].ClientCode = [TblVehCat].ClientCode
WHERE (((TblWordTags.ClientCodeWordPosition) Is Not Null)) and ((TblWords.Word='BM')) And ((TblVehCat.VehCategory ='Motorcycle' ))
ORDER BY WordPosition;