Monday, March 19, 2012

An INSERT command with a subquery

Hi champs!
I am trying to make a short INSERT INTO -command With an subquery SELECT
statement, and it seems that it is not possible; or is it?
INSERT INTO [PeopleInGroups]([PeopleREF], [GroupREF])
VALUES ((SELECT [PeopleID] FROM [People] WHERE initials = 'SSS' ) ,20)
This query goes wrong..
Any suggestion?
/Thanks youINSERT INTO [PeopleInGroups]([PeopleREF], [GroupREF])
VALUES ((SELECT [PeopleID], 20 FROM [People] WHERE initials = 'SSS' )
Regards
R.D
--Knowledge gets doubled when shared
"Kurlan" wrote:

> Hi champs!
> I am trying to make a short INSERT INTO -command With an subquery SELECT
> statement, and it seems that it is not possible; or is it?
> INSERT INTO [PeopleInGroups]([PeopleREF], [GroupREF])
> VALUES ((SELECT [PeopleID] FROM [People] WHERE initials = 'SSS' ) ,20)
> This query goes wrong..
> Any suggestion?
> /Thanks you|||Thanks!
I also found that replacing the "VALUES" with an "SELECT" will also work
INSERT INTO [PeopleInGroups]([PeopleREF], [GroupREF])
SELECT ((SELECT [PeopleID] FROM [People] WHERE initials = 'SSS' ) ,20)
thanks!
"R.D" wrote:
> INSERT INTO [PeopleInGroups]([PeopleREF], [GroupREF])
> VALUES ((SELECT [PeopleID], 20 FROM [People] WHERE initials = 'SSS' )
>
> --
> Regards
> R.D
> --Knowledge gets doubled when shared
>
> "Kurlan" wrote:
>

No comments:

Post a Comment