我想写select c.*,b.* from hy_members as b right join ( select a.* hy_dymanagement as a where a.dymanag_tel in( 09012345678,09012345679 )) on a.dymanag_tel=b.m_driver_tel right join hy_groups as c on c.g_comid =b.m_groupid
这样的sql语句,就是
先查询一个where in,然后在这个查询的表基础上做right join 或者 left join
应该怎么写呢?我这么写报错,我知道不对,可否高手指点一下,谢谢
sqljoin
这样的sql语句,就是
先查询一个where in,然后在这个查询的表基础上做right join 或者 left join
应该怎么写呢?我这么写报错,我知道不对,可否高手指点一下,谢谢
sqljoin
(SELECT a.* FROM hy_dymanagement AS a WHERE a.dymanag_tel IN( 09012345678,09012345679 )) f
ON f.dymanag_tel=b.m_driver_tel
RIGHT JOIN hy_groups AS c ON c.g_comid =b.m_groupid