随便找一个表超过31条记的表,然后就可以这样做了selec A.ID ,B.durtion from (
SELECT '0'||(ROWNUM+900) AS ID from table_1 where rownum<=30) a left outer join table_b b on a.id=b.DATE
SELECT '0'||(ROWNUM+900) AS ID from table_1 where rownum<=30) a left outer join table_b b on a.id=b.DATE
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货