Path: news.cambrium.nl!textnews.cambrium.nl!feeder3.cambrium.nl!feed.tweaknews.nl!postnews.google.com!r36g2000prf.googlegroups.com!not-for-mail
From: Jazz <gery.ducatel@googlemail.com>
Newsgroups: comp.databases.oracle.misc
Subject: Re: complex SQL ?
Date: Fri, 12 Dec 2008 08:02:50 -0800 (PST)
Organization: http://groups.google.com
Lines: 6
Message-ID: <4d561ffb-2b2c-4211-850c-a2a9d3aa3f52@r36g2000prf.googlegroups.com>
References: <f99fe64f-8f98-4519-b5ce-9f9ca2d0b259@q37g2000vbn.googlegroups.com>
NNTP-Posting-Host: 193.113.57.167
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
X-Trace: posting.google.com 1229097770 11272 127.0.0.1 (12 Dec 2008 16:02:50 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Fri, 12 Dec 2008 16:02:50 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: r36g2000prf.googlegroups.com; posting-host=193.113.57.167; 
 posting-account=yTUc0QoAAAC4zBF5VdI4ZZZ_wZnORiXi
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-GB; rv:1.9.0.4) 
 Gecko/2008102920 Firefox/3.0.4,gzip(gfe),gzip(gfe)
Xref:  news.cambrium.nl

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...