橙稚
2017-04-14 01:02
采纳率: 50%
浏览 784

sql语句查询语句问题,

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是有数据的,就是查不出来。
还是这个链接不行!!

  • 写回答
  • 好问题 提建议
  • 追加酬金
  • 关注问题
  • 邀请回答

3条回答 默认 最新

相关推荐 更多相似问题