Re: strsql not showing all records

[Joe Pluta <joepluta@xxxxxxxxxxxxxxxxx>]

lgoodbar@xxxxxxxxxxxxxx wrote:
> SQL != DDS.
>
> Always use an ORDER BY clause on select statements if you intend to
> review the result in a particular order. SQL does not guarantee record
> order otherwise. What you saw was due to how the query optimizer chose
> to access records, based on the different join and where conditions.
>   
This is an excellent point.  I've been bitten by this on more than one 
occasion, especially when the default order came very CLOSE to what I 
was expecting, just slightly different <grin>.  ORDER BY is your friend, 
even if it is a bit tedious (personally, I wish there was an ORDER BY 
PRIMARY-KEY syntax, but I digress).

Joe