SQL - Insert

Results 1 to 2 of 2

Thread: SQL - Insert

  1. #1
    Join Date
    Dec 1969

    Default SQL - Insert

    Can someone please tell me the SQL to add values to a table depending on the value of another field. So for example (in english), insert value1 into table2 if table1.whatever = "true"<BR><BR>Thanks.

  2. #2
    alf Guest

    Default RE: SQL - Insert

    INSERT INTO TABLE2 (FIELD1, FIELD2) VALUES (VALUE1, VALUE2) WHERE TABLE1.FIELDX = &#039TRUE&#039<BR><BR>I think this will work....<BR><BR>alf

Posting Permissions

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