RE: Client Access Express V5

[lisa.thomas@xxxxxxxxxxx]

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.