php - mysql根据用户左连接多个表

Question

我需要连接两个表汽车详细信息和最喜欢的汽车。我使用左连接来连接两个表。

|id| name |Model  |registration |Description  |Variant |status|User Detail Id

|1|  Etios    | Mini  | 123123     |AC Available |Petrol  |Active|51

|1|  Etios    | Mini  | 123123     |AC Available |Petrol  |Active|47

|1|  Etios    |  Mini | 123123     |AC Available |Petrol  |Active|52

|6| Indigo    |  Mini | 123        |AC Available |Gas     |Active|NULL

这是我得到的输出，但我真正需要的是根据 userdetailid 显示汽车。对于 userdetailid='52' 我需要获取第三行和第四行

我使用了这个查询

SELECT `u`.`id`,`u`.`CarName`,`u`.`CarModel`,`u`.`RegistrationNumber`,`u`.`Description`,`u`.`Variant`,`u`.`Status`,`uf`.`CardetailsId`,`uf`.`UserDetailsId` 
FROM `cardetails` AS `u`  LEFT JOIN `favoritecars` AS `uf` ON (`u`.`id` = `uf`.`CarDetailsId`) 
where
u.status = 'Active' and u.CarModel = 'Mini'  and (uf.UserDetailsId='52' or uf.UserDetailsId is null)

请帮助我。提前致谢

Answer 1

如果我理解你的问题是正确的，你的 on 子句一定是ON(u.id = uf.userDetailsId)

SELECT `u`.`id`,`u`.`CarName`,`u`.`CarModel`,`u`.`RegistrationNumber`,`u`.`Description`,`u`.`Variant`,`u`.`Status`,`uf`.`CardetailsId`,`uf`.`UserDetailsId` 
FROM `cardetails` AS `u`  LEFT JOIN `favoritecars` AS `uf` ON (`u`.`id` = `uf`.`userDetailsId`) 
where
u.status = 'Active' and u.CarModel = 'Mini'  and (uf.UserDetailsId='52' or uf.UserDetailsId is