Re: INTO TEMP clause

Posted in 1993

Vinay Gidwani — 30 Jun 1993 18:22:30 GMT — source: Informix-list mailing list archive (1991-1998)

I figured out what I was doing wrong. Apparently it should be SELECT inventory.store_no, inventory.location, inventory.tag_id FROM inventory WHEREinventory.location NOT MATCHES "910-*" AND inventory.store_no IN (SELECT wave_schedule.store FROM wave_schedule WHERE wave_schedule.wave = wv_no) INTO TEMP invtemptab THE INTO TEMP clause should be in the end Vinay