>>How do I include all parts.dbf records in the results?
>
>Another way to do the WHERE first is to do the SELECT in steps, with temporary cursors. I believe I must have done something similar at one time, when I got what I considered at that time to be queer results. In the present case, something like this:
>
>

>select * from Price;
>  where BranchPlant = "123" and Date1 <= ldDate and Date2 >= ldDate;
>  into cursor TempPrice;
>  nofilter
>select *;
>  from parts left outer join TempPrice on Parts.ItemNo = Price.ItemNo;
>  into cursor myResults
>

Using select * is not a good practice. Take a look
Don't use Select * but list Columns (this is for SQL Server, but it's better to use good habits).