inserting multiple rows from one table into another

[xcallmejudasx]

I have a basic understanding of all the sql commands to accomplish this but whenever I try to do anything with the slightest bit of complication I run into issues.

I have 2 tables, partdescriptions and myprojects

DESC defaultengineer.partdescription

Name                    Null     Type           
----------------- -------- -----------------
PID                    NOT NULL VARCHAR2(15 CHAR)
CATEGORY          NOT NULL VARCHAR2(25 CHAR)
WEIGHTTONS      NOT NULL NUMBER(4)        
WEIGHTLBS         NOT NULL NUMBER(4)        
WEIGHTOUNCES   NOT NULL NUMBER(4)        
WEIGHTGRAMS     NOT NULL NUMBER(4)        
CHECKEDOUT       CHAR(1)

DESC defaultengineer.myprojects

Name           Null         Type              
------------ -------- ------------------
PID             NOT NULL  VARCHAR2(15 CHAR) 
ITEMDESC    NOT NULL  VARCHAR2(30 CHAR) 
DUE_DATE    DATE                       
RETURNTO    NOT NULL VARCHAR2(20 CHAR) 
COMPLETED                 CHAR(1)                    
PARTCAT                     VARCHAR2(25 CHAR)

I want to run this query to choose which things to add to my projects

SELECT * FROM defaultengineer.partdescriptions
  WHERE weighttons < 50
    AND category IN ('Custom','T-Joint')
    AND checkedout = 'N'
--this return 7 unique parts

however when I try to run

SELECT pid,category
INTO defaultengineer.myprojects
FROM defaultengineer.partdescriptions
  WHERE weighttons < 50
    AND category IN ('Custom','T-Joint')
    AND checkedout = 'N'

it gives me a missing keyword error. Is it possible to insert multiple rows from one table into another one under these constraints?

[markw8500]

I am not sure about oracle, but I use postgres and select into is like create table... So if I try to use select into with a table that already exists, I get an error well... That the table already exists...

So try to create a new table and see if it works...