stafra for ex... select name,lotno from product inner join lotno on () ...
if there are several lotnos, i want them displyed on a single line
if i do the iiner join i will have multiple lines
thought at a pivot table, but i don't know how many lotnos i have