Untitled

select t1.serialnumber, t1.bin, t1.location, t2.serialnumber , t2.scandate
from alliance.allianceinventoryitem t1
left join inventoryscanitem t2
on t1.serialnumber = t2.serialnumber
where qtyonhand=1 and t1.location like '7-%'
group by t1.serialnumber
limit 1000000;