SQLTeam.com | Weblogs | Forums

SQL help

If I wanted to add a 3rd column to the below code to calculate the margin target ('Target' multiplied by 'Target %') how would I do that?

customer_profile_target.cpt_target As Target,
customer_profile_target.cpt_target_percent As [Target %]

customer_profile_target.cpt_target * customer_profile_target.cpt_target_percent As [Margin Target]