mysql - 如何使用以下 3 个查询进行单个查询？

Question

每次运行这 3 个查询以从 mysql 获取数据时，我都有 3 个 mysql 查询。我如何将这 3 个查询变成单个查询。 Belw 我正在添加查询。

SELECT    b.name as projectname,
          bu.configuration,
          bu.floorpla,
          bu.sqft,
          bu.project_id 
FROM      projects b 
    JOIN  project_units bu ON
          bu.project_id=b.id
    AND   b.is_deleted=0 
WHERE     project_id=?
    AND   bpu.configuration=?
    AND   bu.towername=?
    AND   bu.is_deleted=0
ORDER BY  bu.configuration,
          bu.tower_name

SELECT    b.name as project_name,
          bu.configuration,
          bu.floorpla,
          bu.sqft,
          bu.project_id 
FROM      projects b 
    JOIN  project_units bu ON
          bu.project_id=b.id
    AND   b.is_deleted=0 
WHERE     project_id=?
    AND   bu.configuration=?
    AND   bu.is_deleted=0 
ORDER BY  bu.configuration

SELECT    b.name as project_name,
          bu.configuration,
          bu.floorpla,
          bu.sqft,
          bu.project_id 
FROM      projects b 
    JOIN  project_units bu ON
          bu.project_id=b.id
    AND   b.is_deleted=0 
WHERE     project_id=?
    AND   bu.is_deleted=0 
ORDER BY bu.configuration

Answer 1

这个..怎么样？

SELECT b.NAME AS projectname,
       bu.configuration,
       bu.floorpla,
       bu.sqft,
       bu.project_id

FROM   projects b
       JOIN project_units bu ON bu.project_id = b.id AND b.is_deleted = 0

WHERE  project_id=? AND bu.is_deleted=0 

ORDER  BY bu.configuration, bu.tower_name 

或者这个...

SELECT b.NAME AS projectname,
       bu.configuration,
       bu.floorpla,
       bu.sqft,
       bu.project_id

FROM   projects b 
       JOIN project_units bu ON bu.project_id = b.id AND b.is_deleted = 0

WHERE  bu.is_deleted = 0
       AND ( ( project_id = ? AND bu.configuration = ? AND bu.towername = ? )
              OR ( project_id = ? AND bu.configuration = ? )
              OR ( project_id = ? ) )

ORDER  BY bu.configuration, bu.tower_name  

根据需要选择查询。