比如我有两张表,user(ID,Name), operate(a_ID, type, b_ID)。其中a_ID和b_ID分别是user中的ID值。
现在我想显示 a_ID=1 时的(a_Name, type ,b_Name) ,其中a_Name和b_Name分别是user中的name值。
就赐教,谢谢!
------解决方案--------------------
select (select name from user where id = a_id), type, (select name from user where id = b_id) from operate
where a_id = 1;
------解决方案--------------------
select b.a_Name ,a.Type ,b.b_Name from [operate] a left join [user] b
on a.a_ID=b.b_ID
where a.a_ID=1
------解决方案--------------------
select b.a_Name as [姓名1] ,a.Type ,b.b_Name as [姓名2] from [operate] a left join [user] b
on a.a_ID=b.b_ID
where a.a_ID=1
姓名1 和姓名2 可以自己换
------解决方案--------------------
估计是这样的,但是我的问题没解决。主要是我是要将这些数据绑定到gridview中,有两个字段都是name,那应该不得行哦。
该怎么绑定呢?
select (select name as a_name from user where id = a_id), type, (select name as b_name from user where id = b_id) from operate
where a_id = 1;
------解决方案--------------------
给两个Name列起个不同的别名就行了