Svein Erling Tysvaer wrote:

> At 14:29 29.10.2002 +0200, you wrote:
>
>>The query at the moment looks like this which does not look very
>>elegant. It works however...
>
>
> Are you sure, Gerhardus? You seem to have no link between
> repairauthorisation and reasonsforrejection, so I cannot see how
> authoriseddate actually matters for the subselect.
>
> Set
>

Sorry for taking so long to respond mozilla is not sorting my emails
correctly so I have to search for every message.

I will use a different example.

select estimator,estimatedvalue as Test1,estimatedtime as
Test2,(Test1/Test2) from dar

The problem is Test1 and Test2 is unknown but they do not need to be.

Groete
Gerhardus