Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
siktui82
Starting Member
8 Posts |
 Posted - 2007-06-20 : 22:40:23
|
Hi,
I stuck with the query. I tried to elimate the duplicate records for SELECT query but not avail. Anybody can help? Below is the query.
Thanks.
select arinv.invno, arinvrec.frecref,appohdr.pono
from arinv left join arinvrec on arinv.invno=arinvrec.invno left join appohdr on arinv.splitref=appohdr.soref
where arinv.invno='inv0000006'
invno frecref pono
------------ ---------------- ------------
INV0000006 INV000000601 X0000009
INV0000006 INV000000601 X0000010
INV0000006 INV000000601 X0000043
INV0000006 INV000000602 X0000009
INV0000006 INV000000602 X0000010
INV0000006 INV000000602 X0000043
INV0000006 INV000000603 X0000009
INV0000006 INV000000603 X0000010
INV0000006 INV000000603 X0000043
INV0000006 INV000000604 X0000009
INV0000006 INV000000604 X0000010
INV0000006 INV000000604 X0000043 |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-06-20 : 22:44:30
|
where is the duplicate records ?
KH
|
 |
|
|
siktui82
Starting Member
8 Posts |
Posted - 2007-06-21 : 00:30:10
|
Hi khtan,
actually, i creating crystal report based on the queries. Wanted to show only
INV0000006 INV000000601 X0000009
INV000000602 X0000010
INV000000603 X0000043
INV000000604
instead of PONO and FRECREF result repeating.
|
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-06-21 : 00:32:13
|
that is a formatting / presentation issue. Not a SQL issue. Crystal report should be able to do it easily. I am not familiar with CR, so can't help you with that.
KH
|
|
|
|
siktui82
Starting Member
8 Posts |
Posted - 2007-06-21 : 00:47:06
|
hi kh,
thnks anywhere. 
seem like i have to ask a CR expert. |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-06-21 : 10:24:14
|
In CR, right click on the column and check the check box labelled Suppress if duplicated
Madhivanan
Failing to plan is Planning to fail |
|
|
|
|
|
|
Duplicate records