Topic awaiting preservation: SQL: what's an outer join? — OZONE Asylum, home of the Mad Scientists

This page's ID: 11911

Topic awaiting preservation: SQL: what's an outer join? $Pages that link to <a href="https://ozoneasylum.com/backlink?for=11911" title="Pages that link to Topic awaiting preservation: SQL: what&#039;s an outer join?" rel="nofollow" >Topic awaiting preservation: SQL: what's an outer join?\$

Author	Thread
GRUMBLE Paranoid (IV) Mad Scientist From: Omicron Persei 8 Insane since: Oct 2000	posted 10-16-2001 21:16 can someone give me a short explaination what an outer join is? what he does? and why he should be used? syntax is: ... WHERE table1.col1 = table2.col1 (+) ... thanks!
maestro Nervous Wreck (II) Inmate From: Somewhere out there Insane since: Oct 2001	posted 10-16-2001 21:52 outerjoin? okie say u do a join btw 2 tables based on a attribute (eg. ManagerID), with outerjoin, those tuples with NULL in the ManagerID will also appear. hope this helps! evo.lanche - evolve. the only constant in life.
GRUMBLE Paranoid (IV) Mad Scientist From: Omicron Persei 8 Insane since: Oct 2000	posted 10-16-2001 22:06 oh yes. i think i understood it. only tuples with values of NULL or also 0?
maestro Nervous Wreck (II) Inmate From: Somewhere out there Insane since: Oct 2001	posted 10-18-2001 17:38 only tuples wif NULL values. evo.lanche - evolve. the only constant in life.
GRUMBLE Paranoid (IV) Mad Scientist From: Omicron Persei 8 Insane since: Oct 2000	posted 10-20-2001 00:27 thank you very much for your help, maestro. i understand it now.