Re: subquery with more than one column

great !!

that's what I was lookingfor ...

I think my brain was empty ...

:)


regards,

rai


On 05/07/2007, at 23:27, Jon Sime wrote:

> Raimon Fernandez wrote:
>> [..moved top-post..]
>> On 05/07/2007, at 21:30, Tom Lane wrote:
>>> Raimon Fernandez <coder@montx.com> writes:
>>>> It's not possible to return in a subquery more than one column ?
>>>
>>> Try it like this:
>>>
>>>   SELECT id_intern, (SELECT ROW(referencia, descripcio) FROM
>>> articles WHERE...
>>>
>>>             regards, tom lane
>>>
> > but I want as a separate columns, like a normal SELECT ...
> >
> >
> > this is what I get:
> >
> > +---------------+
> > | row           |
> > +---------------+
> > | (1,"ref rai") |
> > | (1,ref)       |
> > +---------------+
> >
> >
> > thanks,
> >
> >
> > raimon
>
> Is there something about the nature of the data which prevents you
> from using a JOIN between these two tables?
>
>     select pb.id_intern, a.referencia, a.descripcio
>     from product_blister pb
>         join articles a on (a.id_intern = pb.id_product_added)
>     where pb.id_product_source = '8';
>
> (Or using a LEFT JOIN if not every record in product_blister is
> required to have a corresponding record in articles, and you want
> those records in product_blister to still be returned.)
>
> My apologies if my assumption is incorrect.
>
> -Jon
>
> --
> Senior Systems Developer
> Media Matters for America
> http://mediamatters.org/
>