列出两个具有不匹配字段的表中的记录 [英] List out records from two table with unmatching fields

问题描述

祝大家好朋友。我需要帮助：
我有两张表如下：
 
表A 
  TransDate TId金额 
 24 / Apr / 2017 203482 1300 
 24 / Apr / 2017 293877 14500 
 24 / Apr / 2017 121233 15601 
 24 / Apr 2017/76 766534 10500 
 
表B 
  TransDate TId金额 
 24 / Apr / 2017 203482 1300 
 24 / Apr / 2017 293877 14500 
 24 / Apr / 2017 121233 15603 
 
从这两个表中，我想列出金额字段不匹配的所有记录。如有任何帮助，我们将不胜感激。 
 
谢谢。 
 Frank 

我的尝试：

 SELECT TableA.TansDate，TableA.TermId，TableA.Amount 
 FROM TableA INNER JOIN 
 TableB ON TableA.Amount = TableB.Amount 
 WHERE TableB.Amount = TableB.Amount 

解决方案

可能 EXCEPT [ ^ ]将在这里帮助你...

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

What I have tried:

SELECT     TableA.TansDate, TableA.TermId, TableA.Amount
FROM         TableA INNER JOIN
                      TableB ON TableA.Amount = TableB.Amount 
WHERE  TableB.Amount = TableB.Amount

解决方案

Probably EXCEPT[^] will help you here...

这篇关于列出两个具有不匹配字段的表中的记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！