Duplicate records - SQL Server Forums

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.

All Forums

Other Forums

SQL Server 6.5 \ SQL Server 7.0

Duplicate records

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 ?

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.

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

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources