SQLSelect Question

[Don Toro]

It looks like you want to remove any duplicate records from the result. Try the following query.

SELECT DISTINCT Field1, Field2 FROM Table

Donard Toro
Information Manager/Computer Programmer
-------------------------------------------------------------------
Thinking Publications, a division of
McKinley Companies, Inc.
424 Galloway Street, Eau Claire, WI 54703
Phone: 1.800.225.4769 (US) & 1.715.832.2488
Fax: 1.800.828.8885 (US) & 1.715.832.9082
www.ThinkingPublications.com
-------------------------------------------------------------------
COMMUNICATION SOLUTIONS THAT CHANGE LIVES
Specializing in resources for individuals
with speaking, listening, reading, writing, and thinking skill deficits


-----Original Message-----
From: Chuck Pelto [mailto:cbpelto at pcisys.net]
Sent: Thursday, February 02, 2006 1:39 PM
To: Valentina Developers
Subject: SQLSelect Question


This is a rather generic question regarding an SQLSelect call. And I  
hope I do not offend anyone with the simplicity of it, as I do not  
know how to phrase the search in this situation.

I've got a table with multiple fields in it. Heh...like that's  
anything new.

I want to select data from two fields, as part of building this  
contextualmenu (CM) on the fly.

I want the data to be selected to be any records where the  
information in the two fields is distinctly different from any other  
records in that table.

For example...

Field1		Field2		RecID
A			B			1
A			B			2
A			C			3
A			D			4
B			B			5
B			B			6
B			A			7

I would want to cursor to include records 1, 3, 4, 5 and 7. Omitting  
records 2 and 6, because it already has their combinations of data.

How would I phrase the SQLSelect text?

SELECT Field1, Field2 FROM theTable WHERE..........?

Regards,

Chuck
_______________________________________________
Valentina mailing list
Valentina at lists.macserve.net
http://lists.macserve.net/mailman/listinfo/valentina