AnsweredAssumed Answered

Create table from sql query

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


Create table from sql query


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


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