在MySQL中加入两个表[关闭]

Question

Hello guys this is my SQL query:

SELECT * 
FROM path JOIN (
    SELECT * FROM invoice WHERE client_Id='$_SESSION[user]'
) ON INVOICE.path_Id=PATH.Id

I want to join two tables in the first table must have client_Id=$_SESSION[user]. The two tables must be joined on path_Id. Please help me writing this query in right way. Thank you

Answer 1

Try this query

SELECT * 
FROM `PATH` JOIN `INVOICE` 
    ON `INVOICE`.`path_Id`=`PATH`.`Id` 
WHERE `INVOICE`.`client_Id`='$_SESSION[user]'