SELECT * FROM users_data WHERE user_id = {0}

SELECT *
FROM users_data a
INNER JOIN users_type b ON b.id = a.user_type_id
WHERE user_id = {0}

SELECT *
FROM users_data
     INNER JOIN user_type AS NomeAlias ON users_data.valor = NomeAlias.valor
WHERE user_id = {0}

SELECT p.descricao, p.preco_custo, preco_venda, p.qtd_estoque,
       p.qtd_estoque_minimo, marca.nome
FROM produto as p
     INNER JOIN marca AS marca ON marca.id = p.id_marca
ORDER BY marca.nome