multiple select statment in Crystal QRY

i need to have multiple select statement in Crystal query for a report (one to be used in the sub-query) i.e.

select a,b,c from table1 into temp tempn;

select x,y,z from table2
where x not in (select a from tempn
where b=y);

i am using Merant ODBC v3.6 to connect to the informix database . is this possible?