Message
From
15/03/2010 11:44:35
To
15/03/2010 11:42:28
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01454516
Message ID:
01454570
Views:
47
>>>Yes, it should be a LEFT JOIN (was a typo, I assume). Check this link http://blogs.lessthandot.com/index.php/DataMgmt/DataDesign/the-ten-most-asked-sql-server-questions--1#4
>>
>>
>>bu-bu-but i like number 3 and number 1 must i use number 2?
>
>No. Unless your field accepts null, you don't have to do that.
>Cetin
Are you saying it's a common misconception that LEFT JOIN is the fastest method?
>>
>>
>>bu-bu-but i like number 3 and number 1 must i use number 2?
>
>No. Unless your field accepts null, you don't have to do that.
>Cetin
Are you saying it's a common misconception that LEFT JOIN is the fastest method?