sql语句表链接查询一对多

Question

 SELECT * from member_account join member_information on member_account.member_id = member_information.member_id;

我想查询出member_id都是‘a’的sql语句需要怎么写。

Answer 1

已解决，谢谢了。SELECT * from member_account join member_information on member_account.member_id = member_information.member_id where member_account.member_id='a';