<div>
I need a little more context please. &nbsp;This is in an access client against tables that are linked to sql server tables?<br />
<br />
And what datatypes are the columns in the where clause?<br />
<br />
And can you change to this and post the contents of the variable for me:<br />
<br />
Dim sSql as string<br />
sSql = &quot;Select LS.field1, LS.field2, TR.field1, TR.field2, TR.field3, TR.field4 from LSheet as LS, TReport as TR where TR.field5 = LS.field1 and TR.field6 = '&quot; &amp;&nbsp;Text1(0).Text &amp;&nbsp;&quot;'<br />
rs.Open sSql, Con, adOpenKeyset, adLockOptimistic
</div>


I need a little more context please.  This is in an access client against tables that are linked to sql server tables?

And what datatypes are the columns in the where clause?

And can you change to this and post the contents of the variable for me:

Dim sSql as string
sSql = "Select LS.field1, LS.field2, TR.field1, TR.field2, TR.field3, TR.field4 from LSheet as LS, TReport as TR where TR.field5 = LS.field1 and TR.field6 = '" & Text1(0).Text & "'
rs.Open sSql, Con, adOpenKeyset, adLockOptimistic

<div>
First of all Thank you very much for QUICK REPLY :-).<br />
<br />
INNER JOIN query is working perfectly..<br />
Thanks again
</div>


First of all Thank you very much for QUICK REPLY :-).

INNER JOIN query is working perfectly..
Thanks again

<div>
<div class="content wysiwyg-content">
Following query i am running from my VB6 form, it was ok with ACCESS Database but now <br />
i have changed it to SQL Seraver 2008 R2, now its not working showing me 0 records. no error nothing..<br />
<br />

<pre><code id="code-10-27839735-1">Rs.Open &quot;Select LS.field1, LS.field2, TR.field1, TR.field2, TR.field3, TR.field4 from LSheet as LS, TReport as TR where TR.field5 = LS.field1 and TR.field6 = '&quot; &amp; Text1(0).Text &amp; &quot;'&quot;, Con, adOpenKeyset, adLockOptimistic</code></pre>
</div>
</div>


Following query i am running from my VB6 form, it was ok with ACCESS Database but now 
i have changed it to SQL Seraver 2008 R2, now its not working showing me 0 records. no error nothing..

(CODE)

Joint Query

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.