can I link a table using a variable 1

[christer99]

Can I link tables using a variable? (in example below @polvar ) The variable corresponds to a column table. The above code doesn't work

select *
FROM PolicyType PolicyType_1 INNER JOIN
PROSP ON PolicyType_1.TYPE = @polvar LEFT OUTER JOIN
LeadSource ON PROSP.MPLAN = LeadSource.TME LEFT OUTER JOIN
PolicyType RIGHT OUTER JOIN

 

[jbenson001]

You would need to use Dynamic SQL do to this.