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 能不能定时读取XML导入MYSQL数据库的某个表多个列 APMServ5.2.6 mysql提示'root'@'localhost' (using password: YES) 求个MYSQL语句 check table问题 mysql enterprise monitor 中不显示CPU,内存信息 周末了,散点 导入utf8数据文件到数据库出错 java连接Mysql错误,请高手帮助? MySql 5.0 连接问题 一个初学者的小问题,不过很急用 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