Hi Seth, No such thing in MapInfo SQL. It's clearly a subset of the full SQL query set.
However, as opposed to standard SQL, all your queries in MIPro are permanent - in your session or until you close them - and with some restrictions can be used as basis for further queries. You can name these queries, or just use the default (Selection and Query#). E.g. this result: Select Brand,Count(*) From Vehicles Group By Brand Having Count(*) > 5 can be obtained this way in MIPro: Select Brand,Count(*) From Vehicles Group By Brand Select * From Selection Where COL2 > 5 HTH Lars V. Nielsen Odense, Denmark ----- Original Message ----- From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, October 10, 2002 11:59 PM Subject: MI-L SQL - Having Clause > Hi Subscribers, > > I was wondering if anyone knows of a way to use a Having clause in a MapInfo > query. I've tried entering the clause in a query statement in the Mapbasic > window, but I get an error message stating "Unrecognized Command: Having." > I've worked around the problem by running my query results through a second > query, but it would be nice to eliminate the second query if possible. > > Thanks, > Seth Pingree > [EMAIL PROTECTED] > NH Bureau of Emergency Communications > > --------------------------------------------------------------------- > List hosting provided by Directions Magazine | www.directionsmag.com | > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > Message number: 3518 > --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 3527
