AnsweredAssumed Answered

Create table from sql query

Question asked by WalterKnowles on Nov 12, 2014
Latest reply on Nov 14, 2014 by WalterKnowles

Title

Create table from sql query

Post

I've got a table that was imported from an Excel table that "just grewed" out of control. I want to normalize it for analytics and clarity, but I don't seem to find how. I'm probably staring right at it and not seeing what I need.

If this were a traditional SQL database I would issue a SQL command like:

create table cities as select distinct city from manuscripts

or

insert into cities (select distinct city from manuscripts)

but I don't see how I can get myself into a sort of DBA console -- or anyplace else -- to just abstractly execute SQLExecute() function calls. 

What am I not seeing?  RTFM with a page number is probably the answer I'm looking for.

Walt Knowles

Outcomes