Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Selecting records from two different tables in one query
Message
From
15/03/2010 11:44:35
Naomi Nosonovsky
Wisconsin, United States
 
 
To
15/03/2010 11:42:28
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: Selecting records from two different tables in one query
Miscellaneous
Thread ID:
01454516
Message ID:
01454570
Views:
44
>>>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?
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform