2
How would a query that selects between two tables according to the value of a specific column ?
For example: I have two tables that contain account number and Balance, I need to know which accounts do not have the same balance.
Tab1 Conta Saldo 123 100,00 Tab2 Conta Saldo 123 150,00
In case I need to know which accounts are not with the hitting balance.
This helps but with caveats: the tables must be equal or Tab1 not have more columns than Tab2. And will return which records in Tab1 have equal balance in Tab2, not the missing.
– Cleiton Oliveira
@Cleitonoliveira by the question he wants to know only different balances, so there should be accounts in only one of the tables, but I edited the answer.
– Leticia Rosa