>I have a VFP9 app that needs to join these two tables. One is a part table and the other is a price table. They are related by part number. However some parts do not have an entry in the price table but I want all records from the parts table. Also, there is an effective date in the price table.
>
>I tried the following but I don't get the records from parts.dbf included in my results that have no entry in price.dbf.
>
>
>SELECT * ;
> FROM parts LEFT OUTER JOIN price
> ON parts.itemno = price.itemno
> WHERE price.branchplant = '123'
> AND price.date1 <= ldDate and price.date2 >= ldDate
> INTO CURSOR myResults NOFILTER
>
>
>How do I include all parts.dbf records in the results?
>
>Thanks,
>
>Jerry
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham