• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 149
  • Last Modified:

Sqlplus - Query syntax question

Hi,

Im running Oracle 10g and Im having a problem with a query...

My query (not sure if this would be the best way to do it) but it goes through a bunch of table that are related to get a final result.. the problem is that Im getting several duplicated results...

I know ts hard to help like this but I cant give details of the tables..


where
  subs.DPSN_DESTINATIONADDRESS is not null
  and subs.UEMTE_ID is not null
  and subs.UEMTE_ID = terminal.UEMTE_ID
  and terminal.UEMTT_ID is not null
  and terminal.UEMTT_ID = ttype.UEMTT_ID
  and ttype.UEMTT_TERMINALMODELMASTERID = tm.TCRTM_MASTERID

As you can see Im going through the tables...

Fisrt I filter the subs table, then I pass to the ternminal table using the UEMTE_ID (common in both)... then I need the UEMTT_ID to go to the ttype tabel...

The problem is that the UEMTT_ID has a common number in several rows of the ttype table... so thats shy I think Im getting dulicated results...

ANy suggestion?

Tks,
Joao
0
joaotelles
Asked:
joaotelles
2 Solutions
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
please read up this article, it shall explain the "issue" and give you the path to the solution:
http://www.experts-exchange.com/Database/Miscellaneous/A_3203-DISTINCT-vs-GROUP-BY-and-why-does-it-not-work-for-my-query.html
0
 
dannygonzalez09Commented:
have you thought about using Rank() function ? it should help you in removing the duplicates

http://docs.oracle.com/cd/B19306_01/server.102/b14200/functions123.htm
0
 
joaotellesAuthor Commented:
Tks for the articles!
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now