Re: complex SQL ?

Jazz wrote:
> I figured it out, sorry, it is not very complex at all,
>
> SELECT * FROM table t where t.est < t.real;
>
> or also using HAVING clause somehow...

Glad you solved it ... but a couple of pointers.

1. HAVING clause is filtering on groups created by GROUP BY
2. ID is a reserved word
3. REAL is a reserved word

SELECT COUNT(*)
FROM v$reserved_words
WHERE keyword = '<your_word_here>';

Is a valuable query to learn.

-- 
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org