<div>
The only thing I have to say is &quot;Wow!! And they are still in business???&quot;<br />
<br />
Long live MS SQL!!!
</div>


The only thing I have to say is "Wow!! And they are still in business???"

Long live MS SQL!!!

<div>
&gt;&gt;Long live MS SQL!!!<br />
Which is known as the only database engine and tool set without bugs available today...
</div>


>>Long live MS SQL!!!
Which is known as the only database engine and tool set without bugs available today...

<div>
<div class="content wysiwyg-content">
I am trying to get a shipping address list for all of my clients.<br />
I have the following SQL.<br />
SELECT C.CustID, C.CustName, A.AddrId, A.AddrName<br />
FROM Addresses &nbsp;AS A JOIN Customers AS C ON C.CustId = A.CustId<br />
<br />
When I run the SQL by it self I get the first 200 records, but if I insert the result into tmpTable I get the whole list.<br />
<br />
<br />
What gives???
</div>
</div>


I am trying to get a shipping address list for all of my clients.
I have the following SQL.
SELECT C.CustID, C.CustName, A.AddrId, A.AddrName
FROM Addresses  AS A JOIN Customers AS C ON C.CustId = A.CustId

When I run the SQL by it self I get the first 200 records, but if I insert the result into tmpTable I get the whole list.


What gives???

Pervasive SQL 10 only give 200 records on a join querry

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.