Subject SQL problem
Author paultugwell
I'm not sure if this is an appropriate place to post this message, but
if not can somebody suggest a suitable support group I could use.

I have a FB database with 2 tables A and B. If I run the following query

SELECT A.FIELD_A1, A.FIELD_A2
FROM A JOIN B ON A.FIELD_A1 = B.FIELD_B1 AND A.FIELD_A2 = B.FIELD_B2
WHERE B.FIELD_B3 = 'C'

I get a list of all rows in table A that have FIELD_B3 in table B set
to 'C'. I want to run a delete query that deletes all of the rows
returned by this select query, but I can't figure out the correct
syntax. Can someone help please.