>I can try to help you with some code, but I need to ask a few questions:
>
>1) Are you using VS2003 or VS2005?
>
>2) Are the tables mittellog, estimators and reviewerids going to stay as FoxPro tables, or are they SQL Server tables? (Maybe a more general question is whether you're trying to use VB.NET to access a Fox back end or a SQL back end)

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.