A表记录的多个字段和B表的多记录如何实现关联 A表:ID iRank iCity vchrName1 1 5 张三2 2 4 李四3 3 6 王五B表:ID vchrName1 一级2 二级3 三级4 重庆5 成都6 湖南高手指点 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select a.*,b1.v,b2.vchrNamefrom A , b b1, b b2where a.iRank=b1.id and a.iCity=b2.id当您的问题得到解答后请及时结贴.http://topic.csdn.net/u/20090501/15/7548d251-aec2-4975-a9bf-ca09a5551ba5.html select a.id, b.vchrName as iRank, c.vchrName as iCity, a.vchrName from aleft join b on a.iRank=b.idleft join b as c on a.iCity=c.id select a.id,b1.vchrName as iRank,c.vchrName as iCity,a.vchrName from aleft join b as b1 on a.iRank=b1.idleft join b as c on a.iCity=c.id select a.id,b.vchrName as iRank,c.vchrName as iCity,a.vchrName from a inner join b on a.iRank=b.id inner join b as c on a.iCity=c.id 关于向已建立索引的数据库表插入数据元组的问题 升星散分哈! mysql Manager 导出sql文件··急啊~~! 用Dev-Cpp搭建MySQL++编程环境,最后没有产生libmysql.dll…… 如何在MYSQL的QUERY BROWSER 中使用EDIT功能? 请教一条sql语句的问题及优化。 我是新手,请教一下java-mysql的问题? 如何让密码正确区分大小写? 接上个帖子请教sql语句写法 求助贴:有人用过KingbaseES这个软件没?怎么用?有没有教程? sql分页问题, 求去除多列重复值的sql语句
select a.*,b1.v,b2.vchrName
from A , b b1, b b2
where a.iRank=b1.id
and a.iCity=b2.id
当您的问题得到解答后请及时结贴.
http://topic.csdn.net/u/20090501/15/7548d251-aec2-4975-a9bf-ca09a5551ba5.html
a.id,
b.vchrName as iRank,
c.vchrName as iCity,
a.vchrName
from
a
left join b on a.iRank=b.id
left join b as c on a.iCity=c.id
from a
left join b as b1 on a.iRank=b1.id
left join b as c on a.iCity=c.id
from a inner join b on a.iRank=b.id
inner join b as c on a.iCity=c.id