CONSULT DATA FROM A FOREIGN KEY TABLE

Question

I have 3 tables in a database, one houses customer data, other products and one sales, containing foreign table id key products and customers.

I need to make a query that shows the purchases made by the customer of ID = 2, showing his name and the name of the product he bought. The part that confused me was at the time of showing the name of the product purchased, I managed to perform only the following query:

From now on, thank you.

Answer 1

That must be about what you’re looking for.

SELECT
    Cliente.NOME,
    Produto.NOME
FROM
    Vendas
        LEFT JOIN Cliente on (Vendas.IDCliente = Cliente.IDCliente)
        LEFT JOIN Cliente on (Vendas.IDProduto = Produto.IDProduto)
WHERE
    Cliente.IDCliente = 2

Answer 2

I believe that this consultation should resolve:

select c.nome as 'cliente', p.nome as 'produto' from clientes c
join vendas v on v.idcliente = c.idcliente
join produtos p on p.idproduto = v.idproduto
where c.idcliente = 2