如何从表1得到如下查询结果？表1查询结果yearmonthdatayearmonthdata12月人力2013132013131420132420132414
如何从表1得到如下查询结果？
表1查询结果
yearmonthdatayearmonthdata12月人力
20131320131314
20132420132414
20133520133514
20134620134614
20135720135714
20136820136814
20137920137914
2013810201381014
2013911201391114
201310122013101214
201311132013111314
201312142013121414
2012115201211526
2012216201221626
2012317201231726
2012418201241826
2012519201251926
2012620201262026
2012721201272126
2012822201282226
2012923201292326
201210242012102426
201211252012112526
201212262012122626
[解决办法]
select
t1.year,
t1.month,
t1,data,
t2.data
from
表1 t1,
表1 t2
where
t1.year = t2.year and
t2.month = ‘12’