Forum Discussion

pat_energetics's avatar
pat_energetics
Icon for Advocate II rankAdvocate II
10 years ago
Solved

Selectcolumns function

Hi all, Does anyone have any tips or examples on the use of the select columns function to create a new table. I'm trying to create a new table based on an extract of an existing one and their is l...
Need Help
  • Mi2n's avatar
    Mi2n
    10 years ago

    You can better use the query editor window and Duplicate/Reference an existing query in order to create a table with data from another table.

Mi2n's avatar
Mi2n
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

You can better use the query editor window and Duplicate/Reference an existing query in order to create a table with data from another table.

  • pat_energetics's avatar
    pat_energetics
    Icon for Advocate II rankAdvocate II
    10 years ago

    Thanks Mi2n

     

    The suggestion given seems more appropriate for ourapplication. By going back to the source query and duplicating what we need upstream, it seems the resulting table is much easier to work with.