Is it possible to get multiple values from a subquery?

The Solution to Is it possible to get multiple values from a subquery? is


It's incorrect, but you can try this instead:

select
    a.x,
    ( select b.y from b where b.v = a.v) as by,
    ( select b.z from b where b.v = a.v) as bz
from a

you can also use subquery in join

 select
        a.x,
        b.y,
        b.z
    from a
    left join (select y,z from b where ... ) b on b.v = a.v

or

   select
        a.x,
        b.y,
        b.z
    from a
    left join b on b.v = a.v

~ Answered on 2012-09-18 08:08:43


Most Viewed Questions: