求一3表查询的SQL语句

显示全部楼层 · 2010-5-13 22:25:47

select sh_bind.id,sh_bindmsg.name,sh_type.name from sh_bind, sh_bindmsg, sh_type where sh_bind.bid = sh_bindmsg.id and sh_bind.tid = sh_type.id包行的你自己看看是不是表名或是字段名写错了

千问 · 2010-5-13 22:25:47

select a.id,b.name,c.namefrom sh_bind a inner join sh_bindmsg bon a.bid = b.idinner join sh_type con a.tid = c.id =========如果简单表连接,这里很多答案都对问题是你需要的最终效果是什么

千问 · 2010-5-13 22:25:47

select sh_bind.id,sh_bindmsg.name,sh_type.name from sh_bind, sh_bindmsg, sh_type where sh_bind.bid = sh_bindmsg.id and sh_bind.tid = sh_type.id通过主外键关系关联的各表可以进行多表联合查询

千问 · 2010-5-13 22:25:47

select sh_bind.id,sh_bindmsg.name,sh_type.name from sh_bind, sh_bindmsg, sh_type where sh_bind.bid = sh_bindmsg.id and sh_bind.tid = sh_type.id