aurora:find diff 基于主键的两个表之间

iyr7buue 于 2021-06-18 发布在 Mysql

关注(0)|答案(1)|浏览(360)

我有下面的表1

|001000900|aaaaa BELLOWS CORPORATION||N|
|001000905|ddddd DEPARTMENT OF LABOR AND EMPLOYMENT SECURITY|BUREAU OF COMPLIANCE|N|
|001001049|gggg RAVIOLI MFG CO INC|SPINELLI BKY RAVIOLI PASTRY SP|N|
|001001130|dddd ANGELES UNIFIED SCHOOL DISTRICT|TRANSPORTATION BRANCH|N|
|001001143|ffff MUSIC PARTIES, INC||N|
|001001155|BOSTON BRASS AND IRON CO||N|
|001001171|HANCOCK MARINE, INC.||N|
|001001184|TRILLION CORPORATION||N|
|001001192|HAWAII STATE CHIROPRACTIC ASSOCIATION INC||N|
|001001379|THE FRUIT SQUARE PEOPLE INC|L & M BAKERY|N|
|001001416|J & S MARKET||N|

像这样的表2

|001000145|PARADISE TAN||N|
|001000306|SHRUT & ASCH LEATHER COMPANY, INC.||N|
|001000355|HARRISON SPECIALTY CO., INC.||N|
|001000363|LOUIS M. GERSON CO., INC.||N|
|001000467|SAVE THE SEA TURTLES INTERNATIONAL|ADOPT THE BEACH HI|N|
|001000504|DIRIGO SPICE CORPORATION|CUNNINGHAM SPICE|N|
|001000744|FREEDMAN THREAD COMPANY|COLONIAL THREAD CO|N|
|001000756|AFFORDABLE AIR CONDITIONING|P R ENTERPRISE|N|
|001000900|CLIFLEX BELLOWS CORPORATION||N|
|001000905|FLORIDA DEPARTMENT OF LABOR AND EMPLOYMENT SECURITY|BUREAU OF COMPLIANCE|N|
|001001049|SPINELLI RAVIOLI MFG CO INC|SPINELLI BKY RAVIOLI PASTRY SP|N|
|001001130|LOS ANGELES UNIFIED SCHOOL DISTRICT|TRANSPORTATION BRANCH|N|
|001001143|TOSCO MUSIC PARTIES, INC||N|
|001001155|BOSTON BRASS AND IRON CO||N|

我的要求是根据主键查找两个表中存在的行（匹配行），主键是第一列，只有在其他列发生更改时才是第一列。
例如，如果主键是相同的，而它们的其他列是不同的，则至少有一个列将进入输出。
我该怎么做。平淡除了会给我结果吗？

sql mysql amazon-aurora

来源：https://stackoverflow.com/questions/53051082/aurorafind-diff-between-two-tables-based-on-primary-key

1条答案

按热度按时间

6yoyoihd1#

你在找工作吗 join 用一个 where 条件？

select t1.*, t2.*
from table1 t1 join
     table2 t2
     on t1.pk = t2.pk
where not (t1.col2 <=> t2.col2) or
      not (t1.col3 <=> t2.col3) or
      not (t1.col4 <=> t2.col4) ;

赞(0）回复(0）举报 2021-06-18

我来回答

aurora:find diff 基于主键的两个表之间

1条答案

相关问题

热门标签

最新问答