Список записей из двух таблиц с несвязанными полями
Good Day to you all Friend. Please I need help with this: I have two tables as follows: Table A TransDate TId Amount 24/Apr/2017 203482 1300 24/Apr/2017 293877 14500 24/Apr/2017 121233 15601 24/Apr/2017 766534 10500 Table B TransDate TId Amount 24/Apr/2017 203482 1300 24/Apr/2017 293877 14500 24/Apr/2017 121233 15603 From these two tables, I want to list out all the records where the "Amount" fields do not match. Please any help with this will be highly appreciated. Thank you. Frank
Что я уже пробовал:
SELECT TableA.TansDate, TableA.TermId, TableA.Amount FROM TableA INNER JOIN TableB ON TableA.Amount = TableB.Amount WHERE TableB.Amount = TableB.Amount