Syntax for 2 Inner Joins on 2 Group bys

[tinkerz1]

SourceHi,

I am trying to use the same source table to find the maximum for 2 different groups and pull the distinct ID's for them
.

So the max ID of the order number and the Max Cust ID of the customer number.

So then I will have 1 table of both.

Where am I going wrong?

Source1:

LOAD

ID,

Cust-ID,

order_number,

cust_number

FROM $(File)

inner join (Source1)

LOAD

[ID],

MAX(order_number) as [ODnum]

resident (Source1)

group by

[ID];

inner join (Source1)

LOAD

[cust-ID],

MAX(cust_number) as [Cust_num]

resident (Source1)

group by

[cust-ID];

[MK_QSL]

Try Left Join instead of Inner Join

[tinkerz1]

It was just a typo in my join field that threw the exception