in reply to Re: Querying Meta Data
in thread Querying Meta Data

Thats a nice twist on it. Any ideas on weather that is better or worse speed wise?
___________
Eric Hodges

Replies are listed 'Best First'.
Re: Re: Re: Querying Meta Data
by mpeppler (Vicar) on Jul 25, 2003 at 18:41 UTC
    The relative speed of the self-join vs HAVING option is really very difficult to assess - it really depends on the data, the way the indexes are set up, etc.

    In addition I think that HAVING is a Sybase/MS-SQL extension, so it may not be available with MySQL.

    Michael

      Sorry for being late... The query above works perfectly with MySql (v3.23.* and v4.*). Besides that, I think HAVING clause is standard SQL. ++ for your answer!

      Ciao, Valerio