Skip to Content
0
Former Member
Jan 29, 2009 at 09:22 AM

Query problems for pick lists

313 Views

Hi Community,

i got some trouble with a SQL query for pick lists. I am going to create a report, that displays from the pick & pack manager the hole BP and order informations. Therefor i wrote this query, which works properly :

SELECT T3.* FROM PKL1 T0 INNER JOIN RDR1 T1 ON T0.OrderEntry=T1.DocEntry AND 
T0.OrderLine=T1.LineNum INNER JOIN OCRD T3 ON T3.CardCode=T1.BaseCard WHERE
T0.AbsEntry = [%AbsEntry]

My problem is, the bp and order query creates a new line for each row of the pick list. So the bp repeats as often as the order is long. I tried to use a DISTINCT statement, but it does not work.

Any ideas how to solve it ?

Thanks in advance

Steffen