Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cartesian join produces 0 records
Message
From
31/01/2006 11:06:31
Alan Harris-Reid
Baseline Data Services
Devon, United Kingdom
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01091514
Message ID:
01091903
Views:
13
Hi Sergey,

>I suspect that one of the cursors (Cursor1, Cursor2) is empty.

Both cursors had one record, but every field in Cursor2 had a null value, but should that make any difference? I was under the impression that joining a 1-record cursor with another 1-record cursor (with no WHERE clause) would result in a single record. Am I wrong in the case of a totally-empty record?

Regards,
Alan
Previous
Reply
Map
View

Click here to load this message in the networking platform