17,086
社区成员
发帖
与我相关
我的任务
分享
select distinct a.entityid,
a.filename,
a.fileurl,
a.uploadtime,
e.epname eepname,
e.id eid,
c.epname cepname,
c.id cid,
c.epname cepname,
c.carno
from ANNEXDETAIL a, enterprise e, car c
where (a.entityid = e.id and a.entityid = c.id(+))
and a.fileurl = '/upload/anquanyingji/2088/2016-11-09/anquanyingji.pdf';
select distinct a.entityid,
a.filename,
a.fileurl,
a.uploadtime,
e.epname eepname,
e.id eid,
c.epname cepname,
c.id cid,
c.epname cepname,
c.carno
from ANNEXDETAIL a, enterprise e, car c
where (a.entityid = e.id and a.entityid = c.id)
and a.fileurl = '/upload/anquanyingji/2088/2016-11-09/anquanyingji.pdf';