On Sun, Jul 31, 2011 at 8:39 PM, W O <sistemas2000profesional@...>wrote:

> **
>
>
> Hello everybody
>
> - I have a table called CAB
> - CAB has a primary key on column ID_CAB
> - I have a table called DET
> - DET has a foreign key to the column ID_CAB of CAB
> - Now, I want to have a computed column in DET, using a column of DET and a
> column of CAB, something as: TOTALX is CAB.COUNT * DET.PRICE
> - But I cannot do that, the message "column unknown" is showed.
>
> There is some way to do that?
>
> Thanks in advance.
>
> Walter.
>
> [Non-text portions of this message have been removed]
>
>
>

Walter,

I think you would have to create a view based on the joined tables.

Thomas Clarke


[Non-text portions of this message have been removed]