Re: Ambiguous error message

On 3/01, Samuel Tardieu wrote:

| On 2/01, Michael Glaesemann wrote:
|
| | I'm not quite sure what you want the query to return, but you've got a
| | problem with your parentheses.
|
| I can't believe this :) I got hit by the "inner query needs to be aliased"
| message and added it to the wrong place and them munged the query a lot.
|
| The correct one was of course:
| # select texten, total from (select protocolid, count(*) as total from ips
| where catid=1 group by protocolid order by protocolid) as c
| inner join protocols using (protocolid);

(with the "order by" part moved at the end of the query to avoid losing the
order during the inner join)

Sam