SQLSelect Question

[Chuck Pelto]

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