how to filter duplicate field value

In Access and VFP,statement "select distinct fieldvalue from tablename",In
PB,how to filter duplicate field value?
 TKS!


0
Kalmwu
7/7/2001 2:29:44 AM
sybase.powerbuilder.datawindow 28057 articles. 4 followers. Follow

1 Replies
444 Views

Similar Articles

[PageSpeed] 21

Exactly the same way in SQL syntax
eg
  SELECT DISTINCT staff_ref FROM Transactions

The DISTINCT key word will filter the result set to remove duplicate
entries.  Beware using this to 'fix' badly constructed queries such
as those giving the cartesian product of two or more tables.

On Sat, 7 Jul 2001 10:29:44 +0800,
 in powersoft.public.powerbuilder.datawindow
Kalmwu <kalmwu@163.com> wrote: 
>In Access and VFP,statement "select distinct fieldvalue from tablename",In
>PB,how to filter duplicate field value?
> TKS!
>
>

---== Posted via the PFCGuide Web Newsreader ==---
http://www.pfcguide.com/_newsgroups/group_list.asp
0
Paddywhacker
7/6/2001 3:23:29 AM
Reply: