Need SQL to DELETE rows from table

[btturner]

Need help coding SQL delete statement ~

TABLE C O L U M N S
------- ----------------
TBL_A cA cB cC
TBL_B c1 c2 c3

Need to:

Delete all rows from TBL_A
where TBL_A.cA = TBL_B.c1
and TBL_A.cB = TBL_B.c2
and TBL_A.cC = TBL_B.c3

 

[lespaul]

Delete A.* from TBL_A
where TBL_A.cA = TBL_B.c1
and TBL_A.cB = TBL_B.c2
and TBL_A.cC = TBL_B.c3


Leslie

 

[lespaul]

sorry forgot there should be a join in there!




Leslie

 

[btturner]

I realize a JOIN is involved - can someone please provide the syntax? (

 

[lespaul]

Is there a KEY field in either of these table somewhere?

And I was looking for the syntax after my last post.

Leslie

 

[btturner]

No KEY columns sorry --

 

[lespaul]

Maybe something like this:

DELETE FROM Table_A TA INNER JOIN Table_B TB ON TA.cA = T2.c1 AND T1.cB = T2.c2 and T1.cC = T2.c3
WHERE TA.cA = T2.c1 AND T1.cB = T2.c2 and T1.cC = T2.c3

Leslie