Re: Re: Searching (sybase) Database and SQL help (was: Neophyte needs help.)

Neat.

Unfortunately that SQL statement won't work with Sybase - specifically the

select ... 
  from (select ...) alias
[download]

syntax is not supported.

Usually the same thing can be achieved with temporary tables (which is what the above will do under the covers anyway), or with some interesting GROUP BY and HAVING clauses.

Michael

Comment on Re: Re: Searching (sybase) Database and SQL help (was: Neophyte needs help.) Select or Download Code

Replies are listed 'Best First'.
Re: Re: Re: Searching (sybase) Database and SQL help (was: Neophyte needs help.) by BlueBlazerRegular (Friar) on Jun 28, 2002 at 14:51 UTC
Whoops. I'm currently using SQL Server which does allow these types of things and so I thought\|assumed that Sybase did too. A lesson to all you young Monks out there - this is what happens when you don't test your code (or look in the book to make sure it'll work). Going from Sybase to Oracle and now to SQL Server has left me confused on who allows what. I guess I could stay with just the 'core' bits, but that takes all the fun out of things. Pat	[reply]
Re: Re: Re: Re: Searching (sybase) Database and SQL help (was: Neophyte needs help.) by mpeppler (Vicar) on Jun 28, 2002 at 15:10 UTC
Yeah - MS-SQL (and Oracle) have added a lot of syntactic sugar at the SQL level... Michael	[reply]