This might not be the most elegant solution, but, assuming TEXT values, how about:
SELECT column1 column2 FROM table1 where (column1 + column2) NOT IN (SELECT (column1 + column2) FROM table2) Jeff Richardson | Project Manager, Asset Verification Services (AVS) DMA – DuCharme, McMillen & Associates, Inc. | 828 S Harrison Street Suite 650, Fort Wayne, IN 46802 Cell: 724-366-1724 Connect: [email protected]<mailto:[email protected]> | Website<http://www.dmainc.com/> | LinkedIn<https://www.linkedin.com/company/ducharme-mcmillen-&-associates> | Twitter<https://twitter.com/DMATAX> | Facebook<https://www.facebook.com/DMAtaxservices> ___________________________________________________________ ATTENTION: This message and all attachments are PRIVATE, and may contain information that is CONFIDENTIAL and PRIVILEGED. If you have received this message in error, please notify the sender by reply e-mail and delete the message immediately. [cid:[email protected]] From: [email protected] <[email protected]> On Behalf Of Dan Goldberg Sent: Wednesday, December 1, 2021 1:31 PM To: [email protected] Subject: [RBASE-L] - finding values that exist in one table and not another common field link I have two tables with a common link Table1 Column1 Column2 Table2 Column1 Column2 I want to find the values in Column2 in Table1 that does not exist in Table2 based on Column1 in both tables I tried Select Column1, Column2 from Table1, Table2 where Table1.Column1 = Table2.Column1 and Table1.Column1 <> Table2.Column2 But did not work. I am drawing a blank. Anyone have ideas on how? TIA Dan Goldberg -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php<http://www.rbase.com/support/usersgroup_guidelines.php> --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/2E4830CEC16615458329D3D83342F8D0014EEC8183%40EXCHANGE10<https://groups.google.com/d/msgid/rbase-l/2E4830CEC16615458329D3D83342F8D0014EEC8183%40EXCHANGE10?utm_medium=email&utm_source=footer>. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/BL3PR07MB875522568AC1F769748CE20EB4689%40BL3PR07MB8755.namprd07.prod.outlook.com.
