Hi,
I have 2 tables:
Table1 (equity_id,account_id)
Table2 (equity_id,account_id)
I need to find an equity that appears in table1 but does not appear on table2 with the same account_id
Table1
Equity_Id Account_id MSFT 123456 Goog 123456 F 567 MSFT 231
Table2
Equity_Id Acount_id MSFT 123456 Goog 123456
Desired query result:
Equity_Id Account_id F 567 MSFT 231