Hi, I'm using sql 2005 express. The sub select query runs fine when I run it by itself. But I got the following error when I embedded it in this Insert error? Thanks.
INSERT INTO [MedDb].[dbo].[DegreeMajor]
(select distinct degree_Major from dbo.PersonDegree pd
where degree_Major is not null and degree_Major <> '.' and degree_Major <> '')
Msg 156, Level 15, State 1, Line 6
Incorrect syntax near the keyword 'select'.
Msg 102, Level 15, State 1, Line 8
Incorrect syntax near ')'.