Hi,
It's not possible to return in a subquery more than one column ?
SELECT id_intern, (SELECT referencia, descripcio FROM articles WHERE
id_intern = product_blister.id_product_added) FROM product_blister
WHERE id_product_source = '8';
so, I would have to add a new subquery for each column I want to
retrieve ?
like this:
SELECT id_intern, (SELECT referencia FROM articles WHERE id_intern =
product_blister.id_product_added),(SELECT descripcio FROM articles
WHERE id_intern = product_blister.id_product_added) FROM
product_blister WHERE id_product_source = '8';
all of them are from the same table ...
regards,
raimon fernandez