Link to home
Start Free TrialLog in
Avatar of roosterup
roosterup

asked on

how to join several files in as400 sql statement, need an example

Joining multiple files in as400 sql statement. need an example.
Avatar of Gary Patterson, CISSP
Gary Patterson, CISSP
Flag of United States of America image

Select *
from table1 t1
Left outer join table2 t2
On t1.customer = t2.customer
Left outer join table3 t3
On t1.customer = t3.customer
This question needs an answer!
Become an EE member today
7 DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.