Please, try to run this program under VFP6 and under VFP7.
VFP6 returns 2 rows, and VFP7 only 1 row. Can somebody help to explain me this behavior?

Thank you
Norbert Kustra


SET SAFETY OFF
SET STRICTDATE TO 0
SET DATE GERMAN
SET DELETED ON

CREATE TABLE test1 (;
id n(1),;
date1 d(8))

SELECT 0
CREATE TABLE test2 (;
id n(1),;
date2 d(8))


INSERT INTO test1 (id,date1) VALUES (1,DATE())
INSERT INTO test1 (id,date1) VALUES (2,DATE()-1)

INSERT INTO test2 (id,date2) VALUES (1,DATE())

select * ;
from test1 left join test2 on test1.id=test2.id;
where test2.date2<=DATE() INTO CURSOR work1

SELECT work1
BROWSE
SELECT work1
USE
SELECT test1
USE
SELECT test2
USE