我正在研究不同年份(2009 年至 2014 年)的铁路数据,但最近又分别收到了两年(2015 年和 2016 年)的数据。所以我目前的表格如下:
YEAR....REV1....REV2....REV3....REV4....ORG....DEST
2009.....12......14.....15......16......ABC.....ABD
2010.....12......14.....15......16......ABC.....ABD
2011.....12......14.....15......16......ABC.....ABD
2012.....12......14.....15......16......ABC.....ABD
2013.....12......14.....15......16......ABC.....ABD
2014.....12......14.....15......16......ABC.....ABD
2009.....12......14.....15......16......XYZ.....XCV
2010.....12......14.....15......16......XYZ.....XCV
2011.....12......14.....15......16......XYZ.....XCV
2012.....12......14.....15......16......XYZ.....XCV
2013.....12......14.....15......16......XYZ.....XCV
2014.....12......14.....15......16......XYZ.....XCV
请注意,值 12,14,15,16 只是我现在写的随机数,该值不同并且从一年到另一年都不同。并且列表继续为每对不同的 ORG 和 DEST 提供所有年份的行。
YEAR....REV1....REV2....REV3....REV4....ORG....DEST
2015.....12......14.....15......16......ABC.....ABD
2015.....12......14.....15......16......XYZ.....XCV
2015.....12......14.....15......16......VRF.....AVC
2015.....12......14.....15......16......DRE.....ACS
2015.....12......14.....15......16......FRE.....AWD
YEAR....REV1....REV2....REV3....REV4....ORG....DEST
2016.....12......14.....15......16......ABC.....ABD
2016.....12......14.....15......16......XYZ.....XCV
2016.....12......14.....15......16......VRF.....AVC
2016.....12......14.....15......16......DRE.....ACS
2016.....12......14.....15......16......FRE.....AWD
我想要的是一个包含所有年份的表,但只添加那些存在于 ORG 和 DEST 基础上的表,因为新表(2015 年和 2016 年)包含许多其他对 ORG 和 DEST 的数据,我'不感兴趣,而只对我的第一个表格中的那些感兴趣,如下所示:
YEAR....REV1....REV2....REV3....REV4....ORG....DEST
2009.....12......14.....15......16......ABC.....ABD
2010.....12......14.....15......16......ABC.....ABD
2011.....12......14.....15......16......ABC.....ABD
2012.....12......14.....15......16......ABC.....ABD
2013.....12......14.....15......16......ABC.....ABD
2014.....12......14.....15......16......ABC.....ABD
2015 ....12......14.....15......16......ABC.....ABD
2016.....12......14.....15......16......ABC.....ABD
2009.....12......14.....15......16......XYZ.....XCV
2010.....12......14.....15......16......XYZ.....XCV
2011.....12......14.....15......16......XYZ.....XCV
2012.....12......14.....15......16......XYZ.....XCV
2013.....12......14.....15......16......XYZ.....XCV
2014.....12......14.....15......16......XYZ.....XCV
2015.....12......14.....15......16......XYZ.....XCV
2016.....12......14.....15......16......XYZ.....XCV
我对 SQL 比较陌生,所以一直在阅读有关内部连接的内容,但它似乎添加了列而不是我想要的行。关于我如何做到这一点的任何想法?
先感谢您。
+1 为您的努力。Join
适用于匹配 2 个不同的列。你想要的是union
基于 ORG 和 DEST 条件的不同表where
SELECT * FROM Table1
UNION SELECT * FROM Table2 WHERE `ORG` LIKE 'XYZ' AND `DEST` LIKE 'XCV'
UNION SELECT * FROM Table3 WHERE `ORG` LIKE 'XYZ' AND `DEST` LIKE 'XCV'
如果您还需要重复数据,请使用UNION ALL
而不是联合。
本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句