基础和管理
求数据库科普。。。
墨衍会员 · AI 创作全网分发 墨衍智能分发 通过墨衍一键同步至各平台 可同步平台 CSDN微信公众号微博知乎掘金百家号博客园抖音小红书 你的文章也可以这样分发 墨衍会员 ¥399起/年，写一次发全网
我也要 关注 + 加入社区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哪里都去不了。。。
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哪里都去不了。。。
...全文
