大力:有简单的SQL语句吗?如题 结果更正:bh mc1 mc2----------------1 a b2 c c3 b c 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select bh,(select name from b where bh=a.c1) mc1,(select name from b where bh=a.c2) mc2 from b Select a.bh,b.mc as mc1,c.mc as mc2from A表 ajoin B表 b on a.bh = b.bhjoin B表 c on a.bh = c.bh select bh,(select name from b where bh=a.c1) mc1,(select name from b where bh=a.c2) mc2 from a select bh,b.name mc1,c.name mc2 from a join b on a.c1=b.bh join b c on a.c2=c.bh select bh ,mc1=(select mc from B库 where c1=a.bh) ,mc2=(select mc from B库 where c2=a.bh)from A库 a Select a.bh,b.mc as mc1,c.mc as mc2from A表 ajoin B表 b on a.c1 = b.mcjoin B表 c on a.c2 = c.mc txlicenhe(马可) 和 zjcxc(邹建) 你们检查一下你们写的条件。 如何不显示重复值。LEFT OUTER JOIN ,JOIN ,INNER JOIN,distinct 越是简单的越容易出错啊。Select a.bh,b.mc as mc1,c.mc as mc2from A表 ajoin B表 b on a.c1 = b.bhjoin B表 c on a.c2 = c.bh 会有吗?select bh,(select name from b where bh=a.c1) mc1,(select name from b where bh=a.c2) mc2 from a select a.bh,b.name mc1,c.name mc2 from a join b on a.c1=b.bh join b c on a.c2=c.bh SQL数据类型转换 帮忙看下这个查询 如何比较数据的异同?焦急等待中... 求SQL语句实现合并数据 ERP的工艺线路表如何设计?如何跟BOM结合起来? 求一条查询语句,很简单的。60分 请教,SQL Server和Oracle的性能比较 100分,马上给,在线等,关于合并复制,解决了就给分。 高手请进——排序唯一查询????? 急求啊,大神快来帮一下!! 新手问题:关于索引! help !! 数据导入的问题,是不是数据库设计得不好(帮忙顶就给分)
from A表 a
join B表 b on a.bh = b.bh
join B表 c on a.bh = c.bh
(select name from b where bh=a.c1) mc1,
(select name from b where bh=a.c2) mc2
from a
,mc1=(select mc from B库 where c1=a.bh)
,mc2=(select mc from B库 where c2=a.bh)
from A库 a
from A表 a
join B表 b on a.c1 = b.mc
join B表 c on a.c2 = c.mc
from A表 a
join B表 b on a.c1 = b.bh
join B表 c on a.c2 = c.bh
(select name from b where bh=a.c1) mc1,
(select name from b where bh=a.c2) mc2
from a