This error is present what do I change to be able to run this query?

Msg 116, Level 16, State 1, Line 5
Only one expression can be specified in the select list when the subquery is not introduced with EXISTS.

UPDATE abc
SET verified = '1'
WHERE employeenumber = '3'
AND grantedaccess IN (Select * from alphabet WHERE fullOnMaturity = 1)

UPDATE abc
SET verified = '1'
WHERE employeenumber = '3'
AND grantedaccess IN (Select grantedaccess 
 from alphabet WHERE fullOnMaturity = 1)

Or another column you want to check against grantedaccess column.

• Marked as answer by IndigoMontoya 3 hours 45 minutes ago

Instead of * use any column name  or if that  is present in alphabate table

you can not use * in subquery while looking for a single column

UPDATE abc
SET verified = '1'
WHERE employeenumber = '3'
AND grantedaccess IN (Select  <grantedaccess /Col Name of alphabate table >  from alphabet WHERE fullOnMaturity = 1)