JOINS
I. Objectified foreign key
1. Transform foreign key values to records in referenced table
2. Retain nonmatched records only
II. Normal joins
1. Using hashing algorithm
2. Using order-based merge
3. Foreign key joins
4. Cross product
5. Joining files
III. Position-based Joins
1. Location by sequence numbers
2. Location by value positions
3. Location by field positions
IV. A join with sequence
1. Left join
2. Degenerate to cross product
3. Complicated joins
Click to download the PDF file
SPL Official Website 👉 https://www.scudata.com
SPL Feedback and Help 👉 https://www.reddit.com/r/esProc_SPL
SPL Learning Material 👉 https://c.scudata.com
SPL Source Code and Package 👉 https://github.com/SPLWare/esProc
Discord 👉 https://discord.gg/cFTcUNs7
Youtube 👉 https://www.youtube.com/@esProc_SPL