MySql Join 4表

Question

我有4张桌子，我想获取单个客户的预订记录。

TABLE1 (Service_ID  Tax_ID  Cat_ID  S_Name  S_Price)

TABLE2( Order_ID Order_Type Order_Date   Customer_ID     Booking_Type    Booking_Status  Order_No  Car_No)

Table3  (  ID   Order_ID    Service_ID)

Table4(Time_ID  Date_ID Time    Is_Book   Customer_ID     Booking_Status)

Answer 1

我想你可以用JOIN命令把所有的表

SELECT *
FROM TABLE2 a 
INNER JOIN TABLE3 b
ON a.Service_ID = b.Service_ID
INNER JOIN TABLE4 c
ON b.Customer_ID = c.Customer_ID
INNER JOIN TABLE1 d
ON b.Service_ID = d.Service_ID
WHERE d.Customer_ID = ?