Load data from table from Mysql in parts in SELECT

[ioannagr]

Hi all.

I was thinking to load data from a very big table from MySql db in parts in SELECT part.

So I have

LOAD pk from Table1;

INNER JOIN

LOAD pk as pk;

SQL SELECT pk, year from Table2

where year='2020'

UNION ALL

SELECT pk, year from Table2

where year='2021';

Would something like that work? How do i do it with a loop in the SQL SELECT part?