Re: Distinct Records Based On One Field - fixed

I think you still did it wrong, assuming the first column is IDs, but no matter. How do you determine which row from Table2 is "the last record inserted with that number."? Michael PhistucK wrote: I'm posting it again coz I did it all wrong. so here it is again: I got a little problem. I want t

Distinct Records Based On One Field - fixed

I'm posting it again coz I did it all wrong. so here it is again: 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 & Table2 and each number in field1\tfield1 must be output only once (unique)

Distinct records based on one field

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