INSERT + Subquery

[Benedikt83]

Hallo!

Can anyone tell me why this Access-Query doesn't work?

INSERT INTO Pieces (Piece, idComposer)
VALUES ('Song XY', (SELECT idComposer
FROM Composers
WHERE Name = 'ComposerXY'));

An Error is raised that tells that there was no description to it.

Thank you in advance!
Benedikt Höfl

 

[r937]

it doesn't work because you cannot mix VALUES and SELECT like that

try this --

INSERT INTO Pieces (Piece, idComposer)
SELECT 'Song XY', idComposer
FROM Composers
WHERE Name = 'ComposerXY'


rudy

http://r937.com/

 

[Benedikt83]

Thank you rudy, this works!