求数据库科普。。。
digu 2010-12-02 09:18:19 single-row subquery returns more than one row
SELECT (select e.orgname AS subwayname from organization_child c left outer join organization e on c.subwayid=e.orgid where e.region = b.region and b.adddata1 = c.subwayid and c.subwayid = parwayid ) ADDDATA1, (select e.orgname AS subwayname from organization_child c left outer join organization e on c.subwayid=e.orgid where e.region = b.region and b.ADDDATA2 = c.subwayid and c.subwayid = parwayid ) ADDDATA2, (select PARAMname from im_v_param v where v.region = b.region and v.paramtypeid='BUSI_TYPE' and v.PARAMID=b.ADDDATA3)ADDDATA3, ADDDATA4, ADDDATA5 FROM IM_BUSI_EXTEND b,IM_BUSI_OPERA O WHERE B.REGION = O.REGION AND B.REGION AND B.REGION AND
single-row subquery,这里的单行子查询是什么意思?
后面的sql语句中那些 on ADDDATA1 ADDDATA2 ……之类的是什么意思?
要是谁能给告诉我这些sql中那个是单行子查询,那就更加感激不尽了。
大家不要直接给外部链接啊,可以帮我转过来。我除了csdn哪里都去不了。。。