Pervasive SQL 10 only give 200 records on a join querry
Posted on 2009-05-06
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.