Posted by Hilarion on 11/29/05 14:19

> Have you tried a HAVING clause and the end of you sql?
>
> e.g. HAVING username = 'myusername'


That's interresting. I was sure that HAVING clause can
only be used in GROUP BY selects. It's probably some
MySQL feature. It does not work in Oracle 8i (I mean
I can't use aliased name in HAVING clause in it).

Hilarion

• Next in forum: Re: Help with a Query
• Prev in forum: Re: Help with a Query
• Thread view: Re: MySQL -- query that displays rows that can't be joined

[Reply to this message]