These are two fields of more, of three records of my table (for example):

RECORD 1:
field1 = x
field2 = y

RECORD 2:
field1 = x
field2 = z

RECORD 3:
field1 = x
field2 = y

I want a recordset where field1 = x but, not repeat the value of field 2. This is, the recordset must have just two records, the record 1 and 2 (or 2 and 3).

I tryed this sql sentence:

SELECT * FROM table WHERE field1 = 'x'

But get 3 records.

What would be the correct sentence?