select *
from oilDaily left outer join wellInfo
on oilDaily.wellId=wellInfo.wellId and oilDaily.wellId='庆11-001'
group by wellId,oilTime
order by wellId asc,oilTime asc;
select *
from oilDaily left outer join wellInfo
on oilDaily.wellId=wellInfo.wellId
where oilDaily.wellId='庆11-001'
group by wellId,oilTime
order by wellId asc,oilTime asc;