Re: Issues with subqueries !

[William Chiquito]

Hi Cohen,

Try:

SELECT table.id, table.nombre, (SELECT table2.nom FROM table2 Where table2.id_p = table.id) AS nom_p
FROM table WHERE table.id_pers = 10;

Or

SELECT table.id, table.nombre, table2.nom AS nom_p
FROM table
	INNER JOIN table2 ON table.id = table2.id_p
WHERE table.id_pers = 10;