Hello, I have a SQL 2005 Database with two tables that I need to CROSS JOIN in an update query.

The first table is BADGE and column to update is TYPE.

The problem I am having is the part where I need to reference another table UDFEMP column PERSONNELTYPE

so the basic idea is:

update BADGE set TYPE= 16 where TYPE = 66 if udfemp.personneltype = 'NONE'