Hi all I have a query wich I use for labels for our finished product, it takes all lines from a sales order and print 1 label for each product with a serial number, but when there are different products it prints all serials for each product, heres an example so I can make my self more clear.
Sales order:
Item serials
--------------------------------
item1 serial1, serial2
item2 serial3, serial4
item3 serial5
what this query should print are 5 labels:
item1 - serial1
item1 - serial2
item2 - serial3
item2 - serial4
item3 - serial5
But what my query prints is:
item1 - serial1
item1 - serial2
item1 - serial3
item1 - serial4
item1 - serial5
item2 - serial1
item2 - serial2
item2 - serial3
item2 - serial4
item2 - serial5
item3 - serial1
item3 - serial2
item3 - serial3
item3 - serial4
item3 - serial5
so if any one could take a look at my query and tell me where i'm wrong, here's the query:
SELECT dbo.SOP10100.SOPNUMBE, dbo.SOP10201.SERLTNUM, dbo.SOP10100.CUSTNAME, dbo.SOP10200.ITEMNMBR, dbo.IV00101.ITMSHNAM
FROM dbo.SOP10100 INNER JOIN
dbo.SOP10200 ON dbo.SOP10100.SOPNUMBE = dbo.SOP10200.SOPNUMBE INNER JOIN
dbo.SOP10201 ON dbo.SOP10100.SOPNUMBE = dbo.SOP10201.SOPNUMBE INNER JOIN
dbo.IV00101 ON dbo.SOP10200.ITEMNMBR = dbo.IV00101.ITEMNMBR
Thanks in advance.
Regards
