Insert into SQL query problem

Results 1 to 2 of 2

Thread: Insert into SQL query problem

  1. #1
    J Guest

    Default Insert into SQL query problem

    I have a database where is the table numbers and in this table numbers is only one field called number. I need to make sql query which inserts into this field a number if this number not exists in this field numbers. If it exists, nothing happens. I use MS Access database. Thank you if you could write this sql query to me<BR><BR>INSERT INTO numbers (number) values (500) WHERE ...???

  2. #2
    Join Date
    Dec 1969

    Default See ASPFAQs...

    Link at top right of this page.<BR><BR>You can&#039;t normally combine WHERE with INSERT. But see the ASPFAQs and look for an FAQ about "How do I find if record already exists?"<BR><BR>

Posting Permissions

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