sql语句查询语句问题，

Question

SELECT CESHIXIANGMUMINGCHENG AS "国民",JIANCESHIJIAN AS "动脉硬化",ZONGHEPINGFEN AS "亚健康",BAOGAOURL AS "体成分",FPPGJIROULIANG AS "体成",CSSCDZZY AS "平衡",
CEDINGBUWEI AS "骨密度",SHUZHANGYA AS "血压计",CESHIFANGFA AS "心肺",BTGJXISHUZHI AS "平衡仪",KANGYANENGLI AS "精神" FROM t_users
RIGHT OUTER JOIN t_datacenter ON t_datacenter.HUIYUANHAO = t_users.HUIYUANHAO
RIGHT OUTER JOIN t_tichengfen ON t_tichengfen.HUIYUANHAO = t_users.HUIYUANHAO
RIGHT OUTER JOIN t_dongmaiyinghua ON t_dongmaiyinghua.HUIYUANHAO = t_users.HUIYUANHAO
RIGHT OUTER JOIN t_gonglvche ON t_gonglvche.HUIYUANHAO = t_users.HUIYUANHAO
RIGHT OUTER JOIN t_gumidu ON t_gumidu.HUIYUANHAO = t_users.HUIYUANHAO
RIGHT OUTER JOIN t_pinghengyi ON t_pinghengyi.HUIYUANHAO = t_users.HUIYUANHAO
RIGHT OUTER JOIN t_pinghengyigaoduan ON t_pinghengyigaoduan.HUIYUANHAO = t_users.HUIYUANHAO
RIGHT OUTER JOIN t_tichengfengaoduan ON t_tichengfengaoduan.HUIYUANHAO = t_users.HUIYUANHAO
RIGHT OUTER JOIN t_xueyaji ON t_xueyaji.HUIYUANHAO = t_users.HUIYUANHAO
RIGHT OUTER JOIN t_yajiankang ON t_yajiankang.HUIYUANHAO = t_users.HUIYUANHAO
RIGHT OUTER JOIN t_jingshenyali ON t_jingshenyali.HUIYUANHAO = t_users.HUIYUANHAO
WHERE t_users.HUIYUANHAO="000850"

但是t_datacenter表中，会员号000850是有数据的，就是查不出来。
还是这个链接不行！！

Answer 1

右连接以 right join 后的表为主 也就是 t_datacenter 为主， 既然 t_datacenter 有会员号000850是有数据的，你where 条件跟的是 t_users ，结果查不出数据，说明 t_users 这个表没有 000850 这个数据的， 换成 where t_datacenter.HUIYUANHAO="000850" 应该可以 右连接以右表为主