Hi Sergey,

What is IIRC?

I can't move this app into VFP8 yet.

I tried sending the commands one at a time but I still didn't get data back when I executed the 3rd command which joins the two temporary tables so I thought maybe there was an issue with access to the temp tables and sending the command all at once might solve it.

The issue is I need to get a distinct version of the two fields from the INCOME table. Initially I only had one select statement I was executing and I did a left outer join into the INCOME table on the query statement. Then I found that the INCOME table is dirty, having as many as four copies of each row, so my quantites would double, triple, etc. because of the duplicate rows. The INCOME table is imported from another system and there are no controls on it so even if it were cleaned up now I am sure it will have duplicates again in the future.

Margaret