Computed Column Specification

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.On 10 Sep 2006 13:49:17 -0700, Dot Net Daddy wrote:

>Hello,
Hi Dot Net Daddy,
I have just replied to the same question in comp.databases.ms-sqlserver.
In the future, please post your questions to one newsgroup only. That
makes it easier for us to help you, since we can easily see what answers
you've already had, without having to search in other groups as well.
Only questions that really falls between two stools should be posted to
multiple groups - and even then, they should be crossposted (i.e. one
copy that appears in all groups, with answers also appearing in all
groups) rather than multiposted (seperate copies of the message).
Hugo Kornelis, SQL Server MVPsqlsql