Delete multiple records based on data from another table 1

[d1novak]

I have 2 tables tblCOMPANY and tblCOMPANY_ACCESS. TBL_COMPANY has COMPANYID and Sales_Division. tblCOMPANY_ACCESS has COMPANYID and USERID. I need to Delete all records in tblCOMPANY_ACCESS where tblCOMPANY.SALES_DIVISION='Enterprise' and TBL_COMPANY_ACL.USERID='1234'

I tried the following but all records were deleted. yikes!

DELETE FROM tblCOMPANY_ACCESS
WHERE EXISTS
(SELECT COMPANYID,'1234'
FROM tblCOMPANY
WHERE SALES_DIVISION='Enterprise')

any help is greatly appreciated.

 

[markros]

Try

delete T from tblCompany_Access T 
inner join TblCompany TC on T.CompanyID = TC.CompanyID where TC.Sales_Division = 'Enterprise' 
and T.UserID = '1234'

PluralSight Learning Library

 

[d1novak]

Thank you markros!
works Great!