Nested SQL Query

[manofsteel00]

I have a select statement to pull PICKSL, SLOT, PROD, DESC, PACK, MANU ID, HITIX, and PALLET QTY from the (PICKSL) table. The present nested select statement grabs all the records whose product numbers are NOT already in the ALTER table.

PROBLEM: I would like to pull the SLOT field from the TEST table since the PICKSL table does not have a SLOT field. Is there a way to do this in SQL? Thank you very much in advance.

sql = "INSERT INTO MAIN ( PICKSL, SLOT, PROD, [DESC], PACK, " & _
          "[MANU ID], HITIX, [PALLET QTY] ) " & _
          "SELECT p.PICKSL, p.PICKSL, p.PROD, p.DESC, p.PACK, " & _
          "p.MANUID, p.HITI, p.OH " & _
          "FROM PICKSL AS p " & _
          "WHERE Not Exists ( " & _
            "SELECT * " & _
            "FROM [ALTER] a " & _
            "WHERE  a.PROD = p.PROD);"