select A.noticeid, A.CLASS, A.SUBJECT, A.CONTENT,B.this FROM ADM_BLT A left join (select docid,count(docid)"this" FROM ADM_ATTACHMENT group by docid)as Bon A.noticeid= B.docid"as B"这里在Oracle中规范应该怎么写,我初学Oracle。
select A.noticeid, A.CLASS, A.SUBJECT, A.CONTENT,B.this FROM ADM_BLT A left join (select docid,count(docid)"this" FROM ADM_ATTACHMENT group by docid) B on A.noticeid= B.docid 去掉AS!
select A.noticeid, A.CLASS, A.SUBJECT, A.CONTENT,B.this FROM ADM_BLT A left join ( select docid,count(docid)"this" FROM ADM_ATTACHMENT group by docid ) B on A.noticeid= B.docid;
select A.noticeid, A.CLASS, A.SUBJECT, A.CONTENT, B.this FROM ADM_BLT A left join (select docid, count(docid) this FROM ADM_ATTACHMENT group by docid) B on A.noticeid = B.docid
select A.noticeid, A.CLASS, A.SUBJECT, A.CONTENT,B.this FROM ADM_BLT A left join (select docid,count(docid)"this" FROM ADM_ATTACHMENT group by docid) B on A.noticeid= B.docid 是這個this的問題
...
)B on A.noticeid= B.docid
...
select A.noticeid, A.CLASS, A.SUBJECT, A.CONTENT,B.this
FROM ADM_BLT A
left join (select docid,count(docid)"this"
FROM ADM_ATTACHMENT group by docid) B on A.noticeid= B.docid 去掉AS!
select A.noticeid, A.CLASS, A.SUBJECT, A.CONTENT,B.this FROM ADM_BLT A
left join (
select docid,count(docid)"this"
FROM ADM_ATTACHMENT group by docid
) B on A.noticeid= B.docid;
FROM ADM_BLT A
left join (select docid, count(docid) this
FROM ADM_ATTACHMENT
group by docid) B on A.noticeid = B.docid
select A.noticeid, A.CLASS, A.SUBJECT, A.CONTENT,B.this
FROM ADM_BLT A
left join (select docid,count(docid)"this"
FROM ADM_ATTACHMENT group by docid) B on A.noticeid= B.docid 是這個this的問題