Hi All,
I am a complete novice with SQL. I am trying to create a view based on an existing view (I think you are allowed to do this?). here is what my sql looks like:
SELECT *
FROM dbo.enc_serv_view
WHERE (ProgName = [HR (RW) HRRR ]) OR
(ProgName = [HR (RW) HRRR ]) OR
(ProgName = [HR (RW) Mental Hlth ]) OR
(ProgName = [HR (RW) Mental Health +])
When I try to run, I get an error that says "Invalid Column name "HR (RW) HRRR".
Any Ideas as to what I am doing wrong. My goal is to pull all records from the original view where the progname is equal to the values in my where statement.
Any help is appreciated.
D
I am a complete novice with SQL. I am trying to create a view based on an existing view (I think you are allowed to do this?). here is what my sql looks like:
SELECT *
FROM dbo.enc_serv_view
WHERE (ProgName = [HR (RW) HRRR ]) OR
(ProgName = [HR (RW) HRRR ]) OR
(ProgName = [HR (RW) Mental Hlth ]) OR
(ProgName = [HR (RW) Mental Health +])
When I try to run, I get an error that says "Invalid Column name "HR (RW) HRRR".
Any Ideas as to what I am doing wrong. My goal is to pull all records from the original view where the progname is equal to the values in my where statement.
Any help is appreciated.
D