Home » SQL & PL/SQL » SQL & PL/SQL » distinct
distinct [message #37897] Tue, 05 March 2002 09:13 Go to next message
Sam
Messages: 255
Registered: April 2000
Senior Member
Hi,
iam selecting 10 different fields from 3 different tables.
in table A i have a multi inst field, in which i can store multiple values using a unique key.
when i try to retrieve the data from these tables.
iam getting duplicates.
how to select 10 fields as distinct.

Thanks
sam

Report message to a moderator

Re: distinct [message #37912 is a reply to message #37897] Wed, 06 March 2002 01:38 Go to previous message
Manoj
Messages: 101
Registered: August 2000
Senior Member
Hi,

Check your Query may be it is happen due to Lack of join . check it.

Report message to a moderator

Previous Topic: Re: how to copy table content from one to another with order
Next Topic: aproximize date
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 26 04:08:51 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.