select a.ID, a.BANKID, a.CARDNO, b.BANKNAME, c.BANKACCOUNTID, c.FUNDSTYPEID, d.FUNDSTYPECODE, d.REMARK from ACCOUNT_INFO a, BANK_INFO b, TYPE_BANK c, FUNDS_TYPE d where a.BANKID = b.ID(+) and a.ID = c.BANKACCOUNTID(+) and c.FUNDSTYPEID = d.FUNDSTYPECODE
a.BANKID,
a.CARDNO,
b.BANKNAME,
c.BANKACCOUNTID,
c.FUNDSTYPEID,
d.FUNDSTYPECODE,
d.REMARK
from ACCOUNT_INFO a, BANK_INFO b, TYPE_BANK c, FUNDS_TYPE d
where a.BANKID = b.ID(+)
and a.ID = c.BANKACCOUNTID(+)
and c.FUNDSTYPEID = d.FUNDSTYPECODE
a.BANKID = b.ID(+) A表的数据全部检索,也就是你说的以A表为主表。
就是和left join 和right join一样,oracle高版本之后就是用(+)了,你写left join oracle还是会解析成(+)的