SQL Syntax on an AS400

mh53j_fe · #1 (**permalink**) 04-04-06, 12:45

I am brand new to the AS400 and I need some help on the proper syntax to join three or more files in a simple query. Here is an example of a SQL query that joins two files:

SELECT APVENDOR1.VNVENDOR,APVENDOR1.VNVENNAME,
APVENADR1.VAADDRES1, APVENADR1.VACITY, APVENADR1.VASTATE
FROM LAWMOD8/APVENADR1 JOIN LAWMOD8/APVENDOR1
ON VAVENDOR=VNVENDOR

How would I join a third file called lawvendor? I can join the other two files with lawvendor.vendor.

Thanks in advance for your help.

Regards,
Dave

Pat Phelan · #2 (**permalink**) 04-04-06, 13:02

If I reformat your code just a bit, to get:

Code:

SELECT
   APVENDOR1.VNVENDOR, APVENDOR1.VNVENNAME
,  APVENADR1.VAADDRES1, APVENADR1.VACITY
,  APVENADR1.VASTATE
   FROM LAWMOD8/APVENADR1
   JOIN LAWMOD8/APVENDOR1
      ON VAVENDOR=VNVENDOR

I think the logical (syntax) grouping becomes more obvious. You need to repeat the bold section for new tables as you add them to the join, listing the table and the condtion that completes the JOIN operation.

-PatP

mh53j_fe · #3 (**permalink**) 04-04-06, 13:10

Pat,

The lightbulb is now on! Thanks for your help.

Internet Services

Web Development

Digital Marketing

Consumer Tech