select a.Billcode,b.col1,b.col2,a.col3 from
(select * from test where col3 is not null)a,
(select * from test where col1 is not null and col2 is not null)b
(select * from test where col3 is not null)a,
(select * from test where col1 is not null and col2 is not null)b
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货