AS the title states...I really need help on rewriting a line of code but still keeping it working
SELECT C.coCode, C.coName, C.risk, C.curPrice
FROM COMPANY AS C
WHERE C.recom = buy AND C.coCode NOT in
(SELECT H.coCode FROM CLIENTS AS L INNER JOIN HOLDINGS AS H ON L.accountNo = H.accountNo
WHERE L.lastname = sawyer)
I know this is probably a really, really simple and easy code for most but I'm still a beginner at this...I've only learnt this for about 2weeks and our teacher has yet to teach us anything knowledgeable that's currently in my unreasonable assessment which is due in less than 12hours from now...any help would be much appreciated. Thanks!