Re: Computing on column and where?

There are several solutions depending on the following issues:

- is the sub-select returning one row or several rows?
- is "otherClause" depending on mainTable columns?
- is "value" in the where clause depending on otherTable columns?
- is "value" depending on the returning rows of the sub-select?
- ...

Can you tell us more.

--
Michel

Kurt Byrnes <kdb_at_espotmarket.com> a écrit dans le message : 38C511E9.7E69654F_at_espotmarket.com...
> Hello,
>
> I am having difficulty with the following scenario:
> select a, b, (c + (select otherColumn from otherTable where otherClause)
> from mainTable where 3 >= value order by 3
>
> Basically, I want to perform some calculation on a column of a table,
> use the computed value in the where clause, and return the computed
> value.
>
> Any ideas?
>
> Thanks in advance,
>
> Kurt
>
Received on Tue Mar 07 2000 - 10:24:57 CST