Re: Outer Join

From: Francois LeMay <lemayf_at_istar.ca>
Date: 1998/09/17
Message-ID: <mTdM1.27$Ji5.379549@NewsRead.Toronto.iSTAR.net>#1/1

Carl,

        It is the result of a joint relations where you can also see the records that did not mapped with the other relation. Here an example where you would want to join CITIES and BASEBALL_TEAMS..the output may look like this..

CITIES             TEAMS
******             *****

Buffalo
Kingston
Ottawa

New York           Mets
	           Yankees
Chicago            Cubs
SanDiego           Padres

Hope that will help you to understand outer join Francois

In article <6trcma$8qk_at_eng-ser1.erg.cuhk.edu.hk>, phsung_at_se.cuhk.edu.hk says...
>
>Would anyone kindly tell what's the meaning of outer join? Thanks.
>
>regards,
>carl
Received on Thu Sep 17 1998 - 00:00:00 CDT