mysql - 将一个表的多行与另一表的多列匹配mysql

Question

我有 2 张 table

第一个表:联系人列:

Customer ID,Project ID1,Project ID2,Project ID3

因此一个联系人将占一行。

第二个表:时间表列

Project ID, Name, Owner, Hours

一个联系人可以有多个条目。

我想将时间表中的项目 ID 与联系人表的 3 列相匹配。

我正在使用以下查询。

SELECT "Customer ID","Project ID","Project Name","Owner",
        "Hours","Approval Status","Status","Project Manager",
        "Sales Person","Account Manager","Discount %","Hourly Rate",
        "Monthly Budget","Total Budget" 
FROM  "Timesheets" 
    LEFT JOIN "Contacts (Boost Media Group)" 
        ON "Timesheets"."Project ID" = "Contacts (Boost Media Group)"."Zoho Projects ID 1";

但它没有返回所需的结果，因为我无法使用联系人表的项目 ID2、项目 ID3 进行检查。

有什么建议可以解决这个问题吗？

Answer 1

如果我错了，请纠正我。我想当任何条件(Zoho Projects ID 3 或 Zoho Projects ID 2 或 Zoho Projects ID 1)与“时间表”匹配时您需要它们。“项目 ID”

SELECT "Customer ID","Project ID","Project Name","Owner",
        "Hours","Approval Status","Status","Project Manager",
        "Sales Person","Account Manager","Discount %","Hourly Rate",
        "Monthly Budget","Total Budget" 
FROM  "Timesheets" 
    LEFT JOIN "Contacts (Boost Media Group)" 
        ON "Timesheets"."Project ID" = "Contacts (Boost Media Group)"."Zoho Projects ID 1"
or "Timesheets"."Project ID" = "Contacts (Boost Media Group)"."Zoho Projects ID 2"
or "Timesheets"."Project ID" = "Contacts (Boost Media Group)"."Zoho Projects ID 3"