[Solved] Joining 2 fields into another table

Question

$query = "SELECT a.*,b.mobilenumber,b.firstname,b.lastname 
          FROM user_address a 
            left join user b on a.user_id=b.user_id 
          WHERE a.user_id IN 
            (SELECT id FROM user WHERE email="".$email."")";

Accepted Answer

$query = "SELECT a.*,b.mobilenumber,b.firstname,b.lastname 
          FROM user_address a 
            left join user b on a.user_id=b.user_id 
          WHERE a.user_id IN 
            (SELECT id FROM user WHERE email="".$email."")";