CREATE a TABLE on the fly with data from other tables

Tech Talk Databases
1

I wanted to a way to put data into a table but the table did not exist.

New Tablename:
INTO Tool_MiMColors

Here is what you have to do:

select o.id orderID, p.id productdesignID, o.jobnumber, pc.sequence, pc.code, pc.coverage, pc.coatingType 
INTO Tool_MiMColors
from esporder o
INNER Join ebxproductDesign p
ON p.ID=o.productDesignID
INNER Join ebxproductDesignCoating pc
on pc.productDesignID = p.id
where p.autogenerated = 0
and ordertype in (0,2)
and OrderStatus not in ('Cancelled')
order by o.jobnumber, pc.sequence asc

The into and the tablename are the most important command and must go after the select and before the from.