Why does this combination not work?

[#1]

The code in the black text works on its own, but when I add the code highlighted in red it freezes up. Does it have something to do with using the same table (Loans) twice?

Thanks.

Date_First_120:

LOAD

acct_nbr,

FirstSortedValue(prod_dt, prod_dt) as Date_First_120

Resident Loans

Where days_in_arears >= 120

Group by acct_nbr;

Left Join (Loans)

LOAD distinct *

Resident Date_First_120;

Drop Table Date_First_120;

Date_First_30:

LOAD

acct_nbr,

FirstSortedValue(prod_dt, prod_dt) as Date_First_30

Resident Loans

Where days_in_arears >= 30

Group by acct_nbr;

Left Join (Loans)

LOAD distinct *

Resident Date_First_30;

Drop Table Date_First_30;

[Clever_Anjos · Accepted solution]

How many rows Loans table have?

What do you intend with FirstSortedValue(prod_dt, prod_dt) ? Min(prod_dt) isn´t enough?