RE: Client Access Express V5

[Lucas Geheniau <geheniau@xxxxxxxxxxxxxxxxxx>]

--
[ Picked text/plain from multipart/alternative ]
Joining two files as a "left" join works fine,  no problem with two files
joined, but if I join a third file(itembl e.g.) I am losing half of the
records.


At 09:33 AM 26/06/2002 -0500, you wrote:
>It looks like to me that you do not have records in the ITEMASC file for
>every record in the ITEMASA file.
>The default join type is an Inner Join which will not include any rows in
>the table to the left that do not have a corresponding row in the table to
>the right.
>
>If you specify the join as a Left Join, each row in the table to the left
>will be joined with one or more rows in the table to the right.  Any row in
>the table to the left without a corresponding row in the table to the right
>will return the null value for each column in the table to the right.
>
>That's my best guess based on the information.
>
>-----Original Message-----
>From: Lucas Geheniau [mailto:geheniau@bladel.tokheim.com]
>Sent: Wednesday, June 26, 2002 10:22 AM
>To: mapics-l@midrange.com
>Subject: Client Access Express V5
>
>
>--
>[ Picked text/plain from multipart/alternative ]
>Hi,
>
>Using File Transfer from AS400 to PC,  I can join two files without
>problems. e.g.
>AMFLIBA/ITEMASA,AMFLIBA/ITEMBL  t1.itnbr = t2.itnbr   return missing fields
>If I want to add a third file,  only half of the records are listed.
>AMFLIBA/ITEMASA,AMFLIBA/ITEMBL,AMFLIBA/ITEMASC
>t1.itnbr = t2.itnbr AND  t1.itnbr = t3.itnbr  return missing fields.
>
>Using Query does work,  but then I have to run/create  a query and a file
>transfer.
>
>Does anyone know the trick? Or isn't it possible?
>
>Thanks in advance.
>
>Lucas
>
>www.viva-lancia.com
>Best Regards,
>                  Lucas
>
>If you can't convince them, confuse them.(Confucius)
>
>L. Geheniau                                     M.I.S. supervisor /
>Logistic Engineer
>Tokheim Corp.
>Industrieweg 5, 5531 AD Bladel                  The Netherlands
>Fax: +31497381950
>e-mail: geheniau@bladel.tokheim.com
>          l.geheniau@chello.nl
>
>--
>
>_______________________________________________
>This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
>To post a message email: MAPICS-L@midrange.com
>To subscribe, unsubscribe, or change list options,
>visit: http://lists.midrange.com/cgi-bin/listinfo/mapics-l
>or email: MAPICS-L-request@midrange.com
>Before posting, please take a moment to review the archives
>at http://archive.midrange.com/mapics-l.
>_______________________________________________
>This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
>To post a message email: MAPICS-L@midrange.com
>To subscribe, unsubscribe, or change list options,
>visit: http://lists.midrange.com/cgi-bin/listinfo/mapics-l
>or email: MAPICS-L-request@midrange.com
>Before posting, please take a moment to review the archives
>at http://archive.midrange.com/mapics-l.

www.viva-lancia.com
Best Regards,
                 Lucas

If you can't convince them, confuse them.(Confucius)

L. Geheniau                                     M.I.S. supervisor /
Logistic Engineer
Tokheim Corp.
Industrieweg 5, 5531 AD Bladel                  The Netherlands
Fax: +31497381950
e-mail: geheniau@bladel.tokheim.com
         l.geheniau@chello.nl

--