Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
duanecwilson
Constraint Violating Yak Guru
273 Posts |
 Posted - 2009-08-12 : 13:32:25
|
| Include only those records from MyTable1 for which matching MyTable2 records can be found.Include all records from MyTable1, regardless of whether any matching MyTable2 records can be found.--If so, what are they? Would they be Left Join and Left Outer Join respectively?Duane |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-08-12 : 13:35:04
|
First is INNER JOIN, second is LEFT JOIN.
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
duanecwilson
Constraint Violating Yak Guru
273 Posts |
Posted - 2009-08-12 : 13:44:53
|
| Thank you. I appreciate it.Duane |
|
|
|
ddamico
Yak Posting Veteran
76 Posts |
|
|
|
|
|
Do these statements define different JOINS?