on 07-09-2015 3:29 PM
Hello,
Could anyone please advise how I can remove the duplicate entries from my query?
The query is a simple one. I want to report on BP reference numbers, Job locations, when the jobs were completed (date & time), cost centre, project code and the username of the person who raised the sales order.
Select
T0.[NumAtCard], T0.[U_IIS_sskJobLoc], T0.[U_IIS_sskJobStatusD], T0.[U_IIS_sskJobStatusT], T0.[U_IIS_sskCostCode], T0.[Project]
From
ORDR T0 INNER JOIN RDR1 T1 ON T0.DocEntry = T1.DocEntry INNER JOIN OUSR T2 ON T0.UserSign = T2.USERID
Where
T2.[U_NAME] =[%0] AND T0.[NumAtCard] Like '4106_%%'
When the query is executed, most of the lines are duplicated once, twice or three times.
Is there a way I can remove the duplicates?
Many thanks.
Hi
if you do not need RDR1 table, delete from query and you solve your question.
Kind regards.
Agustín Marcos Cividanes
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
98 | |
12 | |
11 | |
6 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.