Is it possible to include a related table in the computation of a column. For example, if I want to store the total of LINE.QTY on ORDER.QTY.
e.g. what is the correct way to express the following pseudo dode:
alter table ORDER
add QTY as sum(LINE.QTY) where line.order_id = order.id
All I can find on MSDN site is that I can't use a subquery.