Originally Posted by WolfShade
"Interesting".. yeah, I guess that's one way to put it.
I've only just recently started learning Oracle, and I prefer (gasp) MS-SQL.
So doing a GROUP BY on the table that is NOT within the wm_concat() should help eliminate (or, at the very least, give a different) error message?
When using anything for GROUP BY, I get either "not a GROUP BY expression" or "not a single-group group expression".
Let me see if I can do anything with my little Oracle (its an express; I'm not sure the version offhand) that can mimic what you are doing here.
Yeah I can't compare; I have a 10g express, so ws_concat and listagg won't be available.
You are trying that just between three tables yeah? If you select more than one field you will need to add it as a part of the group by, or use a subquery (which will be slow).