Subject | SQL problem |
---|---|
Author | paultugwell |
Post date | 2007-09-10T15:07:48Z |
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.
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.