[RESOLVED] SQL Help

[manofsteel00]

I'm trying to write an SQL expression so that I can pull all the data from the TEST table into the MAIN table where the Product number (PROD) of Test is not in the ALTER table. Basically I'm trying to do an INSERT INTO nested query. Here is the code I have so far and it's not working:

INSERT INTO [MAIN] ([PICKSL], [SLOT], [RES],[PROD],[DESC],[PACK],[MANU ID],[HITIX],[PALLET ID],[PALLET QTY],[DFP]) ;
SELECT t.PICKSL, t.SLOT, t.RES, t.PROD, t.DESC, t.PACK, t.[MANU ID], t.HITIX, t.[PALLET ID], t.[PALLET QTY], t.DFP
FROM Test AS t;
WHERE (((Exists (SELECT * 
  FROM [ALTER] a 
  WHERE  a.PROD = t.PROD 
   ))=False));

Any help would be greatly appreciated.