Re: Help on a SQL query

From: max.capo@xxxxxxxxx
Date: 14 Sep 2005 08:28:58 -0700

Unfortunately is not working ...

It returns the following result set:

Contact Company
Job Title Importance
1000000000001637472 1000000000001587309 CCM 200
1000000000001637472 1000000000001587309 CCM 200
1000000000001637472 1000000000001587309 CCM 200
1000000000001637472 1000000000001587309 CCM 200

I need the company field to be unique in the resultset. Moreover, I
don't understand where it has taken the value 200 for importance (on DB
values range from 0 to 170)...

Still thanks for your help
Massi

.

Follow-Ups:
- Re: Help on a SQL query
  - From: Simon Hayes
- Re: Help on a SQL query
  - From: Alexander Kuznetsov

References:
- Help on a SQL query
  - From: max . capo

Prev by Date: Re: oracle pl/sql -> sql server
Next by Date: Re: Help on a SQL query
Previous by thread: Help on a SQL query
Next by thread: Re: Help on a SQL query
Index(es):
- Date
- Thread

Relevant Pages

SqlCeResultSet & DataGrids
... I am having trouble formatting a datagrid that is using a ResultSet as the ... DataSource. ... Does anyone know the mapping name for the tables? ... Prev by Date: ...
(microsoft.public.dotnet.framework.compactframework)
How to get return type (Resultset) information from database storeprocedure object programmatically
... For Example Below are two storeprocedures one returns resultset and ... @Original_ContactName1 IS NULL AND ContactName IS NULL) AND (Phone = ... Prev by Date: ...
(microsoft.public.dotnet.general)
How to get return type (Resultset) information from database storeprocedure object programmatically
... For Example Below are two storeprocedures one returns resultset and ... @Original_ContactName1 IS NULL AND ContactName IS NULL) AND (Phone = ... Prev by Date: ...
(comp.databases.object)
Re: new to jdbc!
... On Sat, 23 Jul 2005 09:19:40 GMT, shya wrote: ... > a particular ResultSet without know them before? ... The answer is forty-two, ... Prev by Date: ...
(comp.lang.java.programmer)
Global change of Company Name
... Is there an easy way to change the company field for an entire domain (approx ... this field one time instead of going to each user object and changing it ... Prev by Date: ...
(microsoft.public.win2000.active_directory)