Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2005
    Posts
    26

    Unanswered: Insert using Select

    I am trying to create a SQL statement that inserts using a select statement. I have done this in other relational databases, but I am getting a syntax error doing this in Access.

    Here's my statement:

    insert into events (client_num, event_num, contact_num)
    values (Select client_num, 1, contact_num from contact where client_num = 16379)

    Any clues if this can be done?

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    Either VALUES or SELECT, not both.
    Paul

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •