本文介绍了查找两个队列之间的数据差异的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
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 / jeffs / archive / 2007/04/19 / Full-Outer-Joins.aspx [ ^ ]
更多推荐
查找两个队列之间的数据差异
发布评论