I got a little problem. I want to show distinct results based on only one field of the record, field1. Here's an example. I want to show records from Table1 and the number in field1 must not show more than once. If my table is this: Table1 field1 field2 field3 field4 5 Five Five One 4 Four Four Bla 5 Five Five Blah 3 Three Three Bluh 5 Five Five Bla bla 6 Six Six Bl.a 8 Eight Eight B.La 9 Nine Nine Lba 3 Three Three LAb
I want to output this: Output field1 field2 field3 field4 5 Five Five Bla bla 6 Six Six Bl.a 8 Eight Eight B.La 9 Nine Nine Lba 3 Three Three LAb Is there a way to do that? without making another table everytime? I mean, by an sql command? Thanks in advance. PhistucK