我有一张桌子test如下
Contract date_prolog hours
-------------------------------
No 20
Yes 24/02/2014 10
No 30
No 10
如何获得此结果？
Contract date_prolog hours
-------------------------------
No 24/02/2014 20
No 24/02/2014 30
No 24/02/2014 10
select contract,
(select date_prolog from test where contract = 'yes') as date_prolog,
hours
from test
where contract = 'no'
本文收集自互联网，转载请注明来源。
如有侵权，请联系 [email protected] 删除。
我来说两句