it worked !!!!!!

Thanks you guys

:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D:-D

also i just tried to filter the duplicates out in excel but im returning 1,200,000 rows so excel cant handle it 🙁

This kinda works

it returns multiple lines for the smae stock iteam but i only need on line per iteam

iv just tried SELECT DISTINCT but this again select all the...