Did you look at creating a Stored Procedure that could create your resultset and simply call the sp?

>Thanks for the help Chris and Kamal. I really like the flexibility VFP offers by creating a new cursor from existing cursors. Ceating a dataview worked this time for me, but I just wonder what I am going to do when I need to create a report that will need multiple SQL select statements to generate a final datatable. Creating a new datatable and populating it with data will work, but it seems a little time consuming to me. Thanks again for the help and have a great day.