Who can hepl me with this query?

[sven2]

Hello,

I am working with an Fe access and BE SQL server and I have to make an update query.

I'm having some trouble to put the WHERE statement in the query ...

The update query looks like this:

update personeels_evaluaties set eindevaluatie = 'j'

and the where statement should be:

SELECT TOP 100 PERCENT Personeelsnummer, Itemnummer, Eindevaluatie
FROM dbo.Personeels_evaluaties
WHERE (Itemnummer IN
(SELECT Cursus_competentie.Itemnummer
FROM Cursus_stam INNER JOIN
Cursus_competentie ON Cursus_stam.Cursusnummer = Cursus_competentie.Cursusnummer INNER JOIN
Cursusplanning ON Cursus_stam.Cursusnummer = Cursusplanning.Cursusnummer INNER JOIN
Cursusdeelnemers ON Cursusplanning.Planningsnummer = Cursusdeelnemers.Planningsnummer
WHERE (Cursus_stam.Cursusnummer = 11) AND (Cursusplanning.Planningsnummer = 15) AND (Cursusdeelnemers.Afwezig = 0))) AND
(Personeelsnummer IN
(SELECT Cursusdeelnemers.Personeelsnummer
FROM Cursus_stam INNER JOIN
Cursus_competentie ON Cursus_stam.Cursusnummer = Cursus_competentie.Cursusnummer INNER JOIN
Cursusplanning ON Cursus_stam.Cursusnummer = Cursusplanning.Cursusnummer INNER JOIN
Cursusdeelnemers ON Cursusplanning.Planningsnummer = Cursusdeelnemers.Planningsnummer
WHERE (Cursus_stam.Cursusnummer = 11) AND (Cursusplanning.Planningsnummer = 15))) AND (Eindevaluatie = N'N')


How can I combine those two query's?

Thanks in advance,
Sven.

 

[wiklendt]

.....and does that select statement return the expected records? what problem exactly are you having?