表关联查询与多条件查询连用要怎么实现

我要通过access_layer表的多个node_id找到member_information表的多个contact_area

 select contact_area FROM member_information JOIN access_layer on node_id WHERE node_id in("4","3","2","1");

select contact_area FROM member_information JOIN access_layer on node_id WHERE node_id in("4","3","2","1");

这个sql有问题，

select b.contact_area FROM member_information a left JOIN access_layer b on a.node_id =b.node_id WHERE a.node_id in('1','2','3','4');