How to make SQL query from multiple tables?

Question

SQL

help to make request:
There are 2 tables: users, orders.
users: id, name, s_name, email
orders: product_name, product_id, user_id
Select: Name, S_name, email ('users') by user_id and matching product_id (orders)

Answer 1

You can use the WHERE ... EXISTS (SELECT ...)

select name, s_name, email
from users
where users.id = 1 and exists (
  select 1 from orders where user_id = users.id and product_id = 2
);

or JOIN

select distinct name, s_name, email
from users
join orders on orders.user_id = users.id
where users.id = 1 and product_id = 2;

MySQL playground

Answer 2

there is a JOIN ... ON for that