Subject | Is possible to have a computed column using a column of another table? |
---|---|
Author | W O |
Post date | 2011-08-01T00:39:02Z |
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]
- 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]