PHP SQL请求 - 查询2个表，用于一个查询的结果

Question

I need to query the database to pull all cars that a particular user likes.

I know that user_id is 1

Then I have 2 tables. 1 contains all the cars ... id and description and table 2 contains the likes.

Table 1 has a list if cars and these fields:

car_id
car_name,
car_description


Table 2 has what cars I like and these fields:

user_id
car_id
likes (1 or 0)

So I need to pull out only the records that user 1 likes from Table 2 but only the ones he likes

What SQL query would I need to do for that?

Answer 1

Try this

SELECT * FROM table1 as t1 LEFT JOIN table2 as t2 on t1.car_id = t2.car_id WHERE t2.user_id = $user_id