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

Reply via email to