table variables alias

[mossbs]

hey guys,

having problems trying to alias a table variable in an update statement

syntax i have so far is....

update @all a
set a.jobtitle = c.job_title from contact
inner join contact c on c.individual_ref = a.ref and c.main_organisation = 'Y'
where a.addresstype = 'Business'

any ideas?

cheers.

 

[RiverGuy]

update  a
set a.jobtitle = c.job_title
[red][b]FROM @all a[/b][/red]
inner join contact c on c.individual_ref = a.ref and c.main_organisation = 'Y'
where a.addresstype = 'Business'