查找两个队列之间的数据差异 [英] Finding data differences between two queires

问题描述

Hello ..我有两个查询导致两个结果集我需要比较两个结果集并需要显示它们之间的差异。希望我会得到很好的支持。谢谢。这些是我的疑问



查询：1

Hello..I have two queries that result two result sets i need to compare both the result sets and need to display the differences between them.Hope i will get good support.Thank you.These are my queries

Query:1

SELECT distinct c.sid_ident,c.fix_ident
   from corept.std_sid_leg as c
   INNER JOIN
   (
      SELECT sid_ident, transition_ident, max(sequence_num) seq, route_type
      FROM corept.std_sid_leg
      WHERE data_supplier='J' AND airport_ident='KBOS'
      GROUP BY sid_ident,transition_ident
   ) b ON c.sequence_num=b.seq
       and c.sid_ident = b.sid_ident
       and c.transition_ident = b.transition_ident
    WHERE c.data_supplier='J' and c.airport_ident='KBOS'
Query:2
SELECT
  name,
  trans
FROM skyplan_deploy.deploy_sids
ON d.name=c.sid_ident
WHERE apt = 'KBOS'
  AND name != trans 

由于Mysql不支持完全外连接，我想到了使用左连接和正确加入并结合两个结果。但我坚持这个。请帮助。我在使用左右连接时出现语法错误。谢谢。

推荐答案

环顾四周： http：// weblogs .sqlteam.com / jeffs / archive / 2007/04/19 / Full-Outer-Joins.aspx [ ^ ]

这篇关于查找两个队列之间的数据差异的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！