Is this sql query possible???

[Enrique Rojas]

Hello I want to make this query but I cannot figure it out.

Say if I have this table

SUP_ID DRV_ID
10000 A
11000 A
12000 A
20000 B
21000 B
30000 C
40000 D
50000 E

What I need is this

10000 A
20000 B
21000 C
40000 D
50000 E

Sup_ID does not really matter any supervisor(SUP_ID) will do. I just
need a list of unique DRV_ID.

[Jason Lepack]

This gives exactly your result:
SELECT Min(SUP_ID) AS MinOfSUP_ID, DVR_ID
FROM tblEnrique
GROUP BY DVR_ID;

But if you only want the DRV_ID then you could use this:
SELECT DISTINCT DVR_ID FROM tblEnrique;

Cheers,
Jason Lepack

Enrique Rojas wrote:

Hello I want to make this query but I cannot figure it out.

Say if I have this table

SUP_ID DRV_ID
10000 A
11000 A
12000 A
20000 B
21000 B
30000 C
40000 D
50000 E

What I need is this

10000 A
20000 B
21000 C
40000 D
50000 E

Sup_ID does not really matter any supervisor(SUP_ID) will do. I just
need a list of unique DRV_ID.

[paii, Ron]

SELECT First(tblName.SUP_ID) AS FirstOfSUP_ID, Samp.DRV_ID
FROM tblName
GROUP BY tblName.DRV_ID;

"Enrique Rojas" <en***********@gmail.comwrote in message
news:11**********************@a75g2000cwd.googlegr oups.com...

Hello I want to make this query but I cannot figure it out.

Say if I have this table

SUP_ID DRV_ID
10000 A
11000 A
12000 A
20000 B
21000 B
30000 C
40000 D
50000 E

What I need is this

10000 A
20000 B
21000 C
40000 D
50000 E

Sup_ID does not really matter any supervisor(SUP_ID) will do. I just
need a list of unique DRV_ID.

[Enrique Rojas]

Thanks gentlemen...that worked.

paii, Ron wrote:

SELECT First(tblName.SUP_ID) AS FirstOfSUP_ID, Samp.DRV_ID
FROM tblName
GROUP BY tblName.DRV_ID;

"Enrique Rojas" <en***********@gmail.comwrote in message
news:11**********************@a75g2000cwd.googlegr oups.com...

Hello I want to make this query but I cannot figure it out.

Say if I have this table

SUP_ID DRV_ID
10000 A
11000 A
12000 A
20000 B
21000 B
30000 C
40000 D
50000 E

What I need is this

10000 A
20000 B
21000 C
40000 D
50000 E

Sup_ID does not really matter any supervisor(SUP_ID) will do. I just
need a list of unique DRV_ID.