Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
NoobNick
Starting Member
2 Posts |
 Posted - 2010-10-08 : 16:43:36
|
| I need to run an update on Table a where Table b = blah blah blah.I am stuck. I am sure this is basic but I just don't get it. I am new to SQL.UPDATE PS_OPR_GRP_3C_TBL a, PSROLEUSER b SET a.GROUP_3C = 'BVW', a.INQUIRY_USE_IND = 'Y', a.ENTRY_USE_IND = 'N' WHERE (b.ROLENAME = 'UA_SA_CC 3C Update' or b.ROLENAME = 'UA_SA_CC 3C View') AND a.ROLEUSER = b.OPRID;Do I need to create a subquery?Thanks,Nick |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
NoobNick
Starting Member
2 Posts |
Posted - 2010-10-08 : 17:15:46
|
| I apologize. |
 |
|
|
|
|
|
Update, aliasing (PeopleSoft, Oracle) - disregard