I cannot do distinct. For the sake of the example, I showed only 1 field but this is the fields SELECT transaction.id as internalid, transaction.tranid, transaction.trandate , item.itemtype, quantitycommitted , quantitypicked, item.id, shipdate, transactionline.transaction, transactionshipment.shippingmethod, shipitem.id , transaction.status as status, BUILTIN.DF(transaction.status) as statusname, transactionline.location, FROM transaction . . You see, it's going to be pretty "bad" Thanks