Re: JBA ML - IQ Objects Question

This is a multipart message in MIME format.
--
[ Picked text/plain from multipart/alternative ]
Bill,

You need to make sure that the outer join '(+)'  is on the file containing
records without matches....in this case SLP05.


Joseph H. Savage Jr
Technical Manager
jsavage@infoalt.com
office: 513-793-2929 x218 or 800-513-9194
fax: 513-936-4040
wireless: 513-604-4620
www.infoalt.com





"William Kanze" <wkanze@bakerlinen.com>
Sent by: jbausers-l-admin@midrange.com
01/10/2002 07:43 AM
Please respond to jbausers-l


        To:     <jbausers-l@midrange.com>
        cc:
        Subject:        JBA ML - IQ Objects Question


OK, my question is, in the knowledgebase I have defined a relationship
between SLP05 Customer Master with all 4 FLP060 Customer Group Code files.
They are all joined on Company and Cust. Grp. Code.  They have all been
defined as "Outer Joins".  When I run my report, I only get the records in
SLP05 that have a match on all 4 FLP060 records.  I was told that an Outer
Join will give me all SLP05 records regardless if it gets a match on any
of
the FLP060 records.  Why am I only getting the ones that match?

_______________________________________________
This is the GEAC/JBA System 21 Users (JBAUSERS-L) mailing list
To post a message email: JBAUSERS-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/jbausers-l
or email: JBAUSERS-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/jbausers-l.