create table sql auto

select 'Keyboard'product_name into table_accessories union
select 'Mouse' union
select 'Keypad' union
select 'Monitor' union
select 'Printer' order by product_name

select * from table_accessories
drop table table_accessories

Please copy code above and paste on query analyzer to see results


Notes:
into table_accessories: auto create table and insert with all query results to table name table_accessories
select * from table_accessories: select all field from table_accessories
drop table table_accessories: remove table_accessories from database