He is using VS2005. Those tables are in VFP presently but will be upscale to SQL Server. That is not a problem presently has he is using my framework which is including a data provider class. The problem here is to combine the two SQLs into one. From there, he will be able to proceed. FYI, we are using VB.NET.
OK, thanks....some code coming in a few minutes...