I am attempting to perform this query in Query Analyzer and I am receiving
the following errors:
If (Select MATRIXID From SUBSC Where (MATRIXID = '00233' Or MATRIXID =
'00203' Or MATRIXID = '00107' Or MATRIXID = '00010'))
Set TIER1 = 'P'
Where ((Select AGEGRP From SUBSC Where AGEGRP = '1') And
(Select FAMSIZ From SUBSC Where FAMSIZ = '1'))
Server: Msg 156, Level 15, State 1, Line 2
Incorrect syntax near the keyword 'BEGIN'.
Server: Msg 156, Level 15, State 1, Line 5
Incorrect syntax near the keyword 'AND'.
Server: Msg 170, Level 15, State 1, Line 6
Line 6: Incorrect syntax near ')'.
Can anyone tell me what I am doing wrong with this query??