|
|
Posted by Dot Net Daddy on 09/10/06 21:41
Hello,
I want to assign a column a computed value, which is the multiplication
of a value from the table within and a value from another table.
How can I do that?
Say the current table is A, column1; and the other table is B, column3.
What should I write as formula?
I tried someting like;
column1 * (SELECT column3 FROM B WHERE A.ID = B.ID)
but it didn't work.
Navigation:
[Reply to this message]
|