Insert query

[sardinka2]

What is wrong with my query?It will not compile
insert into table1
(GID, SID, DateEntered)
values (
select GID,SID,getdate()
from table2
where GID='1' and SID
not in (select SID from table3
where GID='1')
)

 

[SQLSister]

You can't use the values clause and select together.
Try this instead

insert    into    table1
    (GID, SID, DateEntered)
select GID,SID,getdate()
    from table2
    where GID='1'  and SID
             not in (select SID from table3
                where  GID='1')

Questions about posting. See faq183-874