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 |
|
Mohansoft
Starting Member
6 Posts |
 Posted - 2005-09-05 : 11:07:23
|
| what is the difference between cross join and outer join.which join will retrieve the cartesian product from a tableD.Mohan Raj |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-09-05 : 11:10:19
|
| If you have SQL Server installed, have a look at BOL, sql server help fileMadhivananFailing to plan is Planning to fail |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-09-05 : 15:33:10
|
| "what is the difference between cross join and outer join.which join will retrieve the cartesian product from a table"That depends a bit on whether you use a FULL OUTER JOIN, or just an ordinary OUTER JOIN. Which one are you using?Kristen |
|
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2005-09-05 : 17:34:49
|
CROSS JOIN = Cartesian productYou need to read the documentation on joins  What's an "ordinary OUTER JOIN" ?  |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2005-09-06 : 01:58:57
|
| "[i]What's an "ordinary OUTER JOIN"[i] "The other one Kristen |
|
|
|
|
|
|
cross join and outer join