I am trying to get item fulfillments and then join to get the wms pack cartons items and quantity packed and tracking numbers associated with the cartons. Any idea why im getting duplicate rows as the tracking number is being associated with all cartons.

SELECT
	Transaction.ID,
	Transaction.TranID,
	Transaction.TranDate,
	BUILTIN.DF( Transaction.Entity ) AS Customer,
	TrackingNumber.TrackingNumber,
	BUILTIN.DF( CUSTOMRECORD_PACKSHIP_CARTONITEM.custrecord_packship_carton ) AS PackCarton,
	BUILTIN.DF(CUSTOMRECORD_PACKSHIP_CARTONITEM.custrecord_packship_fulfillmentitem) AS PackedItem,
	CUSTOMRECORD_PACKSHIP_CARTONITEM.custrecord_packship_totalpackedqty AS Packed_QTY
FROM
	Transaction
	INNER JOIN TrackingNumberMap ON
		( TrackingNumberMap.transaction = Transaction.ID )
	INNER JOIN TrackingNumber ON
		( TrackingNumber.ID = TrackingNumberMap.trackingnumber)
	INNER JOIN CUSTOMRECORD_PACKSHIP_CARTONITEM ON
		( transaction.id = CUSTOMRECORD_PACKSHIP_CARTONITEM.custrecord_packship_itemfulfillment )
WHERE
	( Transaction.Type = 'ItemShip' )
    AND Transaction.TranID = 'IF23806'
ORDER BY
	Transaction.TranDate DESC,
	Transaction.TranID DESC,
	TrackingNumber.TrackingNumber