VB select distinct Fax, Co_nam from tableA doesn't unique the fax

Thread View: bit.listserv.envbeh-l

1 messages

[T] Back to Threads [V] Tree View [G] Group Articles

1 total messages Started by tom Sat, 10 Nov 2001 05:40

#33

Author: tom
Date: Sat, 10 Nov 2001 05:40

12 lines
1131 bytes

I am using VB to run a select query to unique the fax number from a table, but it only work when I use following query:

    select distinct Fax from tableA where fax is not null

if I use 

    select distinct Fax, Co_nam from tableA 

the result doesn't unique the fax number.

anybody can't help please post a reply and also email to tom@its.com.sg

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads