请教一条sql语句,高手进 select a.name,c.name,d.name from a,a c,a d,b where a.id=b.id and c.id=b.id and d.id=b.id 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select * from a inner join (select id1 as id from bunion select id2 as id from bunion select id3 as id from b) AS TT on tt.id=a.id 写错了条件:select a.name,c.name,d.name from a,a c,a d,b where a.id=b.id1 and c.id=b.id2 and d.id=b.id3 select id1=(select name from a where id=b.id1),id2=(select name from a where id=b.id2),id3=(select name from a where id=b.id3) from b 求重复记录查询的SQL语句,急! 请教一个sql语句 百分求一SQL查询问题。 有关C#创建存储过程 MS SQL语句,哪个函数可以计算一个字符串在另一个字符串出现的位置,比方说: 'AB'在'CDEAB'的位置是4,类似VB的INSTRT和EXCEL的MID 语句操作 sql2000 两表数据比较 SQL语句 case when then 的问题。 求一条SQL语句。。。。。。。。。。。。。 行转列问题,解决立马结贴 我想用一个帐号,去访问另一个帐号建的存储过程,应该怎么解决啊? 另一个查询SQL语句的问题!高手进来,又100分!
(select id1 as id from b
union
select id2 as id from b
union
select id3 as id from b) AS TT on tt.id=a.id
select a.name,c.name,d.name
from a,a c,a d,b
where a.id=b.id1 and c.id=b.id2 and d.id=b.id3
id2=(select name from a where id=b.id2),
id3=(select name from a where id=b.id3)
from b