Untitled

select bbs.warehouse_code, bbs.bin_code,plts.pallet_type from (
	SELECT DISTINCT bbs.warehouse_code, bbs.bin_code, bbs.pallet_number from bin_balances as bbs 
	where pallet_number = 'MHITA00096'
) bbs
inner join pallets plts on plts.pallet_number = bbs.pallet_number
GROUP by bbs.warehouse_code, bbs.bin_code
having COUNT(plts.pallet_type) = 1