php - 将 2 个字段连接到另一个表中

Question

如何将表 1 中的两个字段连接到表 2？

我在下面有这段代码，我如何将用户表中的字段“mobilenumber”、“firstname”和“lastname”加入到 user_address 表中？

 $query = "SELECT * FROM user_address WHERE user_id IN 
  (SELECT id FROM user WHERE email = '".$email."')";

标签： phpmysql

Answer 1

$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."')";