SELECT ; A.Invoice, ; ShipDate, ; Oslsm, ; Prodct, ; Cust, ; QtyOrd, ; Oprice, ; QtyUpd, ; Ocompc, ; A.ShipDue, ; Terr, ; WrHse, ; Scity, ; Sstate, ; A.Year, ; A.Month ; FROM ; OrdrDtlH A, OrdrHdrH ; INTO TABLE ShipHst ; WHERE ; A.Invoice = OrdrHdrH.Invoice .AND. ; Year = '1999' .AND. ; Month = '12'Yes, even though it seems odd, Year and Month are Character fields.