On Tue, Aug 22, 2006 at 06:47:51PM -0700, chrisj wrote:
> The first query works fine, but when a second sub-query is added I get a
> syntax error...
>
> psql protocal2 -U p2user << EOF1
> select *
> from serv_res SR
> where serv_key = 10
> and not exists
> (select 1
> from reservation R
> )
> -- and not exits
Does the real query have "exits" instead of "exists"? I created
some test tables and fixed that typo and then both queries worked.
--
Michael Fuhr