simple insert statement

[PatrickB]

INSERT INTO Application_Table (XID, APPLICATION)
VALUES (SELECT b.XID, b.application1
from User_app_assignment B
where b.application1 is not null
group by b.xid);

 

[PatrickB]

n/m i see the error of my ways.

INSERT INTO Application_Table ( XID, APPLICATION )
SELECT [User_app_assignment].[XID], [User_app_assignment].[Application1]
FROM User_app_assignment
WHERE ([User_app_assignment].[Application1] Is Not Null)
GROUP BY [User_app_assignment].[Application1], [User_app_assignment].[XID];