我想加红色部分,可是一加就出错,请问我该如何改正啊?SELECT x.*,n.* FROM hy_clientinfo as x RIGHT JOIN ( SELECT c.*,d.* FROM hy_groups as c RIGHT JOIN ( SELECT b.*,f.* FROM hy_members AS b where b.m_membername = 'LONGCHENG' RIGHT JOIN ( SELECT a.* FROM hy_dymanagement AS a WHERE a.dymanag_tel IN( 09012345679,09012345678 )) f ON f.dymanag_tel=b.m_driver_tel) d ON c.g_id =d.m_groupid )n on x.c_memberid=n.m_id ----------
也就是说,下面的表格我只想取出一条数据来
。。 g_createtime m_id m_comid m_membername m_katakana m_belongs 。
10:51:29 1 1 group01 2012-10-09 17:44:51 29 1 Li 09012345678 1 2012-10-11 10:43:36 1 1 group01 2012-10-09 17:44:51 10 1 LONGCHENG 09012345679 1 2012-10-
也就是说,下面的表格我只想取出一条数据来
。。 g_createtime m_id m_comid m_membername m_katakana m_belongs 。
10:51:29 1 1 group01 2012-10-09 17:44:51 29 1 Li 09012345678 1 2012-10-11 10:43:36 1 1 group01 2012-10-09 17:44:51 10 1 LONGCHENG 09012345679 1 2012-10-
SELECT x.*,n.* FROM hy_clientinfo as x RIGHT JOIN ( SELECT c.*,d.* FROM hy_groups as c RIGHT JOIN ( SELECT b.*,f.* FROM hy_members AS b RIGHT JOIN ( SELECT a.* FROM hy_dymanagement AS a WHERE a.dymanag_tel IN( 09012345679,09012345678 )) f ON f.dymanag_tel=b.m_driver_tel) d ON c.g_id =d.m_groupid )n on x.c_memberid=n.m_id where n.m_membername = 'LONGCHENG'
谁来,我给分
( SELECT c.*,d.* FROM hy_groups AS c RIGHT JOIN
( SELECT b.*,f.* FROM hy_members AS b RIGHT JOIN
( SELECT a.* FROM hy_dymanagement AS a WHERE a.dymanag_tel IN( 09012345679,09012345678 )) f
ON f.dymanag_tel=b.m_driver_tel WHERE b.m_membername = 'LONGCHENG' ) d ON c.g_id =d.m_groupid )n ON x.c_memberid=n.m_id