|
|
Posted by Stefan Rybacki on 09/05/05 11:21
Martin wrote:
> Stefan:
>
> Thanks. The only thing I had to debug was to change UNION to UNION
> ALL. UNION returns only unique values; UNION ALL returns all values.
>
> Now, for my education, why is the "x" just ahead of GROUP BY
> necessary? If I remove it, no records are returned, so it's obviously
> needed. But I don't understand what it actuall IS.
>
You have always to name a derived table, I just called it x thats all.
Stefan
PS: I don't know your db design at all but if you want to do such things, please review
your design
> Martin
> ...
>
Navigation:
[Reply to this message]
|