General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>> Additionally, you can quickly cause a Cartesian product if you use SELECT * with any kind of join condition. <<
SELECT * really has no to do with a Cartesian join. A Cartesian join occurs when you join two tables and don't provide a join condition. In that case, every record from the first table is matched with every record from the second table.
However, in general, it is better to select only the fields you need, particularly if VFP has to create a disk presence for the result.
Tamar
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only