If you get this you need to break up your sql into 2 SQL statements making sure they each contain a unique id. Then combine them into one table.... SELECT temp1.* , temp2.* FROM temp1, temp2 WHERE temp1.uniqueid = temp2.uniqueid INTO CURSOR final.

above is most likely does not have the correct syntax...but you should get the idea. I had to do this one time for a report where there werent too many fields but the string itself exceed some limit because each field had to be prefaced with tablename and was written 'tablename.fieldname AS resultname' because i was doing a UNION.

If you cant get it to work...post the actual SQL also what version of Foxpro???

Glenn