Interesting, but error message is now “Subquery returned more than one record.”

>Bob,
>
>Would something like this work for you? (I did not test)
>
>

>select G.cStyle, G.kGarment, G.cDescrip, G.nDefPrice, ;
>       cast(nvl((select "A" from LocGarment LG where LG.kGarment = G.kGarment), "X")  as C(1))  as cType;
>  from Garments G
>