Sign up now to view this solution! It's quick, easy, and secure to subscribe. We will return you to this solution, unlocked, when you’re done.
Question
DELETE statement
Hi guys,
Simple delete statement help required here:
DELETE *
FROM TBL_A, TBL_B
WHERE TBL_A.ID = TBL_B.ID
Will the above query delete all records in both TBL_A and TBL_B?, because I only need to delete the records in TBL_A.
I have also tried:
DELETE *
FROM TBL_A
WHERE (SELECT * FROM TBL_A, TBL_B WHERE TBL_A.ID = TBL_B.ID)
This gives me some EXISTS keyword error, hence what I simply want is to DELETE all the records from TBL_A that has IDs that match those IDs in TBL_B.
Solution
About this Solution
View This Solution - Start Your 30 Day Free Trial- Zone
- general
- Tags
- Participating Experts
- 6
- Solution Grade
- B
Posted on 2003-07-02 at 07:37:41ID: 35598441
All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.