-
SQL 2005 CROSS JOIN Query help
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'
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|