Closed Thread Icon

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&amp;#039;s an outer join?" rel="nofollow" >Topic awaiting preservation: SQL: what&#039;s an outer join?\

 
Author Thread
GRUMBLE
Paranoid (IV) Mad Scientist

From: Omicron Persei 8
Insane since: Oct 2000

posted 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 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 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 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 posted 10-20-2001 00:27

thank you very much for your help, maestro.
i understand it now.

« BackwardsOnwards »

Show Forum Drop Down Menu