17,377
社区成员
发帖
与我相关
我的任务
分享
select pr.logid,pr.siteid,pr.recodtime,po.dynamos,po.elecqty from productlog pr left outer join powerunits po on pr.logid=po.logid and pr.siteid=po.siteid
where pr.recodtime between to_char(Trunc(sysdate,'month'),'yyyy-mm-dd') and to_char(sysdate,'yyyy-mm-dd');
select pr.logid,pr.siteid,pr.recodtime,po.dynamos,po.elecqty from productlog pr left outer join powerunits po on pr.logid=po.logid and pr.siteid=po.siteid
where pr.recodtime between to_char(Trunc(sysdate,'month'),'yyyy-mm-dd') and to_char(sysdate,'yyyy-mm-dd');