Neophyte: sub-select returning multpile rows

[marknel]

Originally posted by DaPi
The reason why you are getting a Cartesian product is because there is no condition relating "T215 a" to the sub query "(SELECT . . . ) b" - you would have to add another WHERE clause at the end.

But more simply, why not soemthing like:

SELECT  a.c1, enumval.value
FROM  T215 a, FIELD_ENUM_VALUES enumval
WHERE enumval.schemaid = 215
AND   enumval.fieldid = 7
AND   enumval.enumid = a.c7

Wow.. Okay that worked very nicely.
Thank you. Now to change the rest of the monstrosity that I called a query to fit this.

I might be back