Ah... You can try adding distinct
>>Interesting, but error message is now “Subquery returned more than one record.”
select G.cStyle, G.kGarment, G.cDescrip, G.nDefPrice, ;
cast(nvl((select distinct "A" from LocGarment LG where LG.kGarment = G.kGarment), "X") as C(1)) as cType;
from Garments G
"The five senses obstruct or deform the apprehension of reality."
Jorge L. Borges?
"Premature optimization is the root of all evil in programming."
Donald Knuth, repeating C. A. R. Hoare
"To die for a religion is easier than to live it absolutely"
Jorge L. Borges