Can anyone explain why this works:

SELECT * from order WHERE VAL(order.emp_no) IN ;
		(SELECT dly_emp.emp_no FROM dly_emp WHERE ;
			dly_emp.tTimeIn < order.tInit )

and this doesn't(Note that the ".OR. .T." is the only change)?

SELECT * from order WHERE VAL(order.emp_no) IN ;
		(SELECT dly_emp.emp_no FROM dly_emp WHERE ;
			dly_emp.tTimeIn < order.tInit .OR. .T.)

This throws error 1801: "Error correlating fields". I was obviously trying to do real comparing instead of just ".OR. .T.", but numerous tests proved that this causes these problems. A simple ".T. or .T." or ".F. or .T." doesn't, however... Ideas? Work-a-rounds to this BUG in VFP7 SP1? Any acknowledgement by Microsoft? Thanks.


FYI: order.emp_no is string, dly_emp.emp_no is numeric, and tTimeIn and tInit are DateTime with some empty values in the dly_emp table.