Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2010
    Posts
    40

    Unanswered: Spliting query results

    Hello,
    How can I split the results of the query in table 1 (given below) and insert them into corresponding columns of table1
    Code:
    INSERT INTO table1 (col1, col2) 
    SELECT DISTINCT(othercol3,othercol4) FROM table2
    Thanks

  2. #2
    Join Date
    May 2008
    Posts
    277
    DISTINCT is not a function, so don't use parentheses.

Posting Permissions

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