SQL -Distinct?

[vbmorton]

Thought I would post to see if anyone had any ideas of how to do the following.

i have this sql statment connecting to as400.

 Set rsNewTravelers = New Recordset
 
    
 strsql = "select dtdept, dtrsrc, dtjobr, dtseq#, dtpart from " & g_strDataBase & ".CURPX1, " & g_strDataBase & ".CJOBH where dtjobr = dnjob and dnprnt <> 'Y'"


 rsNewTravelers.Open strsql, g_Conn

This code works but I would like to make it distinct by dtjobr.


Thanks

 

[fredericofonseca]

this is not a VB question, but a SQL one.

Please post it on the correct forum (either Ansi SQL or your particular DB)

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

 

[vbmorton]

Yes, very good, I know it is a SQL question, but it is SQL that i wrote in my VB6 program. I was just wondering if anyone might have any ideas to change my SQL statment so that i can have less VB code later in my program weeding out the duplicates.

 

[zemp]

For Access and SQL server you could try,

"Select Distinct ...."

But as Frederico mentioned it all depend on your DB and whether it support the use of the distinct keyword.

zemp