注意:我没有共享数据库模式，因为我主要是在寻求帮助，只是w.r.t.最后一步是2个子查询的“左外连接”。select*from(selectidfromActionwhereid=3)ASact1leftOuterJoin(selectAction.name,completed_AtascompletedAt,deadline,notes,ActionAssignedTo.action_IdasactionId,fromActioninnerjoinEmployeeonAction.created_By_Id=Employee.idandEmployee.vendor_Id=2inne