Insert into for more than 1 record

[sven2]

Hello,

How can I insert the results of the query below into the table uitnodigingen?

the query:

SELECT dbo.Cursusplanning.Planningsnummer, dbo.Cursusdeelnemers.Personeelsnummer, dbo.Werknemers.Achternaam, dbo.Werknemers.Voornaam
FROM dbo.Cursusplanning INNER JOIN
dbo.Cursusdeelnemers ON dbo.Cursusplanning.Planningsnummer = dbo.Cursusdeelnemers.Planningsnummer INNER JOIN
dbo.Werknemers ON dbo.Cursusdeelnemers.Personeelsnummer = dbo.Werknemers.Personeelsnummer
WHERE (dbo.Cursusplanning.Planningsnummer = 7)

Thank in advance,
Sven.

 

[HiTechCoach]

Open the query in the query designer and then change the type to an Append query.

 

[sven2]

Hello,

I am working with an adp project and so I can't change it to to an Append query in the designer ...

I tried it like this but it doesn't work

INSERT INTO Uitnodigingen
SELECT Cursusplanning.Planningsnummer, Cursusdeelnemers.Personeelsnummer, Werknemers.Achternaam, Werknemers.Voornaam
FROM Cursusplanning INNER JOIN
Cursusdeelnemers ON Cursusplanning.Planningsnummer = Cursusdeelnemers.Planningsnummer INNER JOIN
Werknemers ON Cursusdeelnemers.Personeelsnummer = Werknemers.Personeelsnummer
WHERE (Cursusplanning.Planningsnummer = 7)

Sven.

 

[jal]

Maybe you need a VALUES clause (what error are you getting?). The words in red assume that the table Uitnodigingen has those exact column names. If not, change the words in red to the actual column names used in the Uitnodigingen table.


INSERT INTO Uitnodigingen (Planningsnummer, Personeelsnummer, Achternaam, Voornaam)
SELECT Cursusplanning.Planningsnummer, Cursusdeelnemers.Personeelsnummer, Werknemers.Achternaam, Werknemers.Voornaam
FROM Cursusplanning INNER JOIN
Cursusdeelnemers ON Cursusplanning.Planningsnummer = Cursusdeelnemers.Planningsnummer INNER JOIN
Werknemers ON Cursusdeelnemers.Personeelsnummer = Werknemers.Personeelsnummer
WHERE (Cursusplanning.Planningsnummer = 7)

Also your inner join syntax seems wrong for Access. At least up till Access 2003, you need to add parentheses as follows. Add a closing paranthesis to each inner join line, and then cluster all the opening parentheses after the FROM clause. Like this:

SELECT t1.* FROM (((((((((t1
INNER JOIN t2 on t1.ID = t2.ID)
INNER JOIN t3 on t3.id = t2.ID)
INNER JOIN t4 on t4.id = t3.id)
INNER JOIN t5 on t5.id = t4.id)
INNER JOIN t6 on t6.id = t5.id)
INNER JOIN t7 on t7.id = t6.id)
INNER JOIN t8 on t8.id = t7.id)
INNER JOIN t9 on t9.id = t8.id)
INNER JOIN t10 on t10.id = t9.id)