Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2010
    Posts
    4

    Unanswered: (RESOLVED) Select into 'as'?

    I would like to select everything from one column in one table to another column in another table. Normally I would just do "SELECT INTO" except this time, the column header names are different. One table calls it userName & the other calls it userID.

    How do I SELECT INTO as something else?
    Last edited by SergioM; 05-16-13 at 18:07. Reason: RESOLVED

  2. #2
    Join Date
    Jun 2010
    Posts
    4
    I thought this was close. But does not work

    SELECT userName
    INTO adUsers_SD.userID
    FROM adUsers

  3. #3
    Join Date
    Jun 2010
    Posts
    4
    Found it! Please disregard this post

    INSERT INTO adUsers_SD (userID)
    SELECT userName
    FROM `adUsers`

Tags for this Thread

Posting Permissions

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