its a vehicle information system rite, which means one number can be associated with multiple customers.

and its can have standard number and customer number. if this understanding is rite then

(Data you shared after joining the both subqueries)

LoadNumber CUSTOMER CUSTOMERPickPalletCountcon_count

AL75152 CD113 AS029 2 21

AL75152 GI005 AS029 3 21

What is your expected output ?