Re: Help with subselect statements
Date: 1998/05/28
Message-ID: <01bd8a4c$3a5a83c0$4958b784_at_w0015479.mgh.harvard.edu>#1/1
Here is one simple example in Ingres 1.2/00 that works:
select testnum, testdate from test t
where exists (select *
from test s
where s.testnum = t.testnum
and s.tid != t.tid)
order by testnum asc;
sadaf_at_unb.ca wrote in article <6kcbav$fm0$1_at_nnrp1.dejanews.com>...
> Hi,
>
> Could anyone please tell me how to use subselect statements within the
FROM
> clause for Ingres? Can we use a subselect statements within the SELECT
clause
> in Ingres? How does it work? Is there a good place on the internet to
look
> for SQL statements?
>
> Thank you everyone in advance. I will appreciate it a lot if someone
could e-
> mail me the answers to my questions.
>
> Thanks,
> Sadaf
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/ Now offering spam-free web-based newsreading
>
Received on Thu May 28 1998 - 00:00:00 CEST