mysql - SQL WHERE 查询，编辑现有查询

Question

我正在完成一项工作，负责 SQL 的团队成员之一去度假了。我有以下查询:

SELECT
    Car.*, 
    Building.*, 
    CarType.* 
FROM 
    Car 
    INNER JOIN Building ON 
        Car.BuildingID=Building.BuildingID 
    INNER JOIN CarType ON 
        Car.CarType=CarType.TypeID

这将返回我们需要的有关汽车和建筑物的所有信息，但是，我们需要根据请求表中称为状态的字段的值来编辑查询，如果该字段不= “接受”，那么不显示建筑物或汽车的信息？

我尝试过以下方法:

SELECT 
    Car.*, 
    Building.*, 
    CarType.*, 
    Requests.* 
FROM
    Car 
    INNER JOIN Building ON 
        Car.BuildingID=Building.BuildingID 
    INNER JOIN CarType ON 
        Car.CarType=CarType.TypeID 
WHERE 
    Requests.Status <> 'Accepted'

但是这不起作用任何帮助，将不胜感激谢谢

Answer 1

您的查询中缺少请求表。假设 Car 表中有一个字段 RequestID，您的查询应如下所示

SELECT Car.*, Building.*, CarType.*
FROM Car 
INNER JOIN Building ON Car.BuildingID=Building.BuildingID
INNER JOIN CarType ON Car.CarType=CarType.TypeID
INNER JOIN Requests ON Car.RequestID = Requests.RequestID
WHERE Requests.Status = 'Accepted'

注意，我已将 Requests 表连接到 Car 表，假设两者都包含一个名为 RequestID 的字段