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 |
|
sqadil
Starting Member
11 Posts |
 Posted - 2009-10-26 : 14:44:54
|
| Please can any of u explain how and when can a full outer join can be used. What are the benefits... can give with example...??????/ Thanking you in advance......!. |
|
|
mfemenel
Professor Frink
1421 Posts |
Posted - 2009-10-26 : 15:03:57
|
| It's pretty rare to use it. The only time it's been useful to me is when I needed to create a big chunk of test data. That's about itMike"oh, that monkey is going to pay" |
 |
|
|
jimf
Master Smack Fu Yak Hacker
2875 Posts |
Posted - 2009-10-26 : 15:13:35
|
| I use it somewhat frequently in Auto Insurance. There are policies where the drivers out number the vehicles and policies where the vehicles out number the drivers. Not all drivers are assigned a vehicle and not all vehicles are assigned a driver, so a FULL JOIN is the way to go to get all the drivers and all the vehicles on a policy.JimEveryday I learn something that somebody else already knew |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-10-27 : 14:01:02
|
| its used in places where you need to merge data from two tables on a condition and also need to include all records from both tables regardless of a match. |
|
|
|
|
|
|
full outer join