I’m pretty new to SQL in base, I’ve got a few queries set up now with a little help (thanks JohnSUN) which is great. I’m now exploring and have successfully used the DELETE FROM command for removing multiple entries from a table but would like to go a little further.
Rather than individually deleting rows by using…
DELETE FROM “table”
WHERE “Column” = ‘1234’
I’d rather delete entries from the first table by matching entries from a column in a second table. I’ve had a good go but don’t yet have a good enough grasp of sql to figure it out for myself.
Hopefully thats clear and thanks in advance to anyone who can help