问个多表连接的问题 select a.hynm,a.hyh,b.knm,da_k.kh,c.knmfrom da_hy as a Left join da_k as b on a.hynm= b.hynm inner join da_k_kz as c on b.knm 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select da_hy.hynm,da_hy.hyh,da_k.knm,da_k.kh,da_k_kz.knmfrom da_k t2 right join da_hy t1 on t2.hynm=t1.hynm inner join da_k_kz t3on t2.knm=t3.knm select da_hy.hynm, da_hy.hyh, da_k.knm, da_k.kh, da_k_kz.knmfrom da_k inner join da_k_kzon da_k.knm = da_k_kz.knmright join da_hyon da_hy.hynm = da_k.hynm 这样select da_hy.hynm,da_hy.hyh, da_k.knm,da_k.kh, da_k_kz.knm from da_hy left outer join da_k on da_hy.hynm = da_k.hynm inner join da_k_kz on da_k.knm = da_k_kz.knm 谢谢chludlf(春露)和libin_ftsafe(子陌红尘)的解答,我明白了 求助:弄了很久的SQL条件判断查询。。。。。 请教一个行记录相减 大家好 我是sql新手 请问 EXEC CFM..xp_cmdshell 'bcp CFM..testtable out e:\123.xml -c -T -k' 为什么产生不了文件 如何批量添加数据 如何获取DATABASE中所有TABLE中的数据笔数? 关于sql2005中的维护计划运行失败 请各位大大进来看下这两个存储过程,有何改正之处?? 如何在sql中读取image 菜鸟的查询问题! 一个简单的sql语法问题?达人请进! 中英文混合截取字符串 请问如何重新设置自增长ID列
da_k.knm,da_k.kh,
da_k_kz.knm
from da_k t2 right join da_hy t1 on t2.hynm=t1.hynm inner join da_k_kz t3
on t2.knm=t3.knm
da_hy.hynm,
da_hy.hyh,
da_k.knm,
da_k.kh,
da_k_kz.knm
from
da_k
inner join
da_k_kz
on
da_k.knm = da_k_kz.knm
right join
da_hy
on
da_hy.hynm = da_k.hynm
select da_hy.hynm,da_hy.hyh, da_k.knm,da_k.kh, da_k_kz.knm from da_hy left outer join da_k on da_hy.hynm = da_k.hynm inner join da_k_kz on da_k.knm = da_k_kz.knm