|
-- [ 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 --
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.