Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
???
- Thread starter Yogi39
- Start date
I think this will work:
DELETE
FROM T1
WHERE T1.MyPrimaryField in
(
SELECT DISTINCT T2.MyPrimaryField
FROM T2
)
If not, please give more info... Terry M. Hoey
th3856@txmail.sbc.com
While I don't mind e-mail messages, please post all questions in these forums for the benefit of all members.
DELETE
FROM T1
WHERE T1.MyPrimaryField in
(
SELECT DISTINCT T2.MyPrimaryField
FROM T2
)
If not, please give more info... Terry M. Hoey
th3856@txmail.sbc.com
While I don't mind e-mail messages, please post all questions in these forums for the benefit of all members.
- Thread starter
- #3
- Status