Subject Ordering using a Computed Column for Lookups
Author Martin D. Berezaga
I have a SQL like:
select A.ID, ...., (select B.DESCRIPTION from B where B.ID = A.ID) as
A_DESCRIPTION
from A;

A_DESCRIPTION has it COMPUTED CheckBox checked.

So, A_DESCRIPTION is a computed column based on a singleton select used to
keep a description column up-to-date with a Lookup Dataset, which SQL is:
select B.ID, B.DESCRIPTION from B;

I'd like to enable ordering based on the computed column, using it in
OrderingItems/OrderingLinks. But I'm getting a 'Columns Unkown' error.

How can I do?

Thanks in advance.
---------------------------
Martin D. Berezaga
mdberezaga@...
ICQ : 18537142
Porto Alegre - RS - Brasil
---------------------------

_______________________________________________________________________
Yahoo! GeoCities
Tudo para criar o seu site: ferramentas fáceis de usar, espaço de sobra e acessórios.
http://br.geocities.yahoo.com/