Inserting a fixed value and also selected values into table

[emozley]

Hi,

I have a table called Users which has a column UserID and Department. I want to add every UserID that has a department value of 3 to a table called Attendees:

INSERT INTO Attendees
SELECT UserID AS UserID
FROM Users
WHERE Department=3;

This works fine but the Attendees table also has a column called MeetingID. If I wanted to make add the value 100 to this column for all records inserted is this possible?

cheers

Ed

 

[r937]

INSERT
INTO Attendees
( UserID
, MeetingID )
SELECT UserID
, 100
FROM Users
WHERE Department=3


r937.com | rudy.ca

 

[emozley]

Excellent thanks very much.