Multiply different fields based on field value in CTE construct
In a CTE construct I want to know if there is a way to multiply different
fields between fields in CTE definition and fields in main query based on
a field value in the main query ?
For example in CTE construct there are Width1 and Width2 fields. In the
main query there are Height1, Height2 and DIM_Type
Is it possible to add calculated fields for result from Width1 * Height1
if DIM_Type = 1 And Width2 * Height2 if DIM_Type = 2 ?
No comments:
Post a Comment