Coding in RPG (IBM i/AS400). How to make different JOINs to retrieve data
In this video I'd like to show you an example of how you can use different kind of JOINs to retrieve information from our tables.
I'm making an example of INNER JOIN, LEFT JOIN, RIGHT JOIN and FULL JOIN.
Please, let me know what you think about it. Leave your comments below.
Don't forget to subscribe!
#ibmi #ibm #rpg #rpgle #rpgfree #newvideo #ibmtraining #ibmcoding #rpgtraining #as400 #common #modernize #embeddedSQL #modernRPG #SQL #sqljoins
0:00 Introduction
0:12 Starting with the "Run SQL Scripts" utility
0:25 Showing the tables that Im going to use in the example and the data
1:45 First example: INNER JOIN or JOIN
4:20 You can also do it in other way (trick!)
5:09 Second example: LEFT JOIN
7:33 Third example: RIGHT JOIN
8:40 Forth example: FULL JOIN
11:47 Final comments and ending