我该如何定义一个视图,其中包含两个计算字段,例如...
('TableName'.'BlueSquares' + 'TableName'.'RedSquares') AS TotalSquares, ('TableName'.'BlueCirles' + 'TableName'.'RedCircles') AS TotalCircles
...并创建第三个计算字段,该字段基于前两个计算字段,如下所示...
('ViewName'.'TotalSquares' + 'ViewName'.'TotalCircles') AS TotalShapes
当我按名称引用前两个计算字段时,会收到未知字段的消息。
谢谢!