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'