http://qs321.pair.com?node_id=664276


in reply to Re: (OT) Exclusion selection on DBI
in thread (OT) Exclusion selection on DBI

I'm going to update the node. There is a column I've not talked about.
Anyway, the problem about GROUP approach is that it selects only the last row of each group. It produces:

Orange, green
Mellon, white

But I really need to see the complete list of rows where fruit.name is repeated:

Orange, yellow
Orange, green
Mellon, red
Mellon, white

Thanks!