Qualify unique values from a tale column
Sigþór Hrafnsson <[email protected]>
| Newsgroups | gmane.comp.web.webobjects.devel |
|---|---|
| Message-ID | <[email protected]> |
This is completely eluding me. I want to qualify based on unique values from a column in a table, like Have a table User with a column ipAddress, in the table there can be more that one user by the same name with the same ipAddress but a different table id. User Table example User john ip 111 id 1 (simplified for demonstration) User Bart ip 222 id 2 User Elsa ip 333 id 3 User john ip 111 id 4 With the EOQualifier, I would like to get the result for table id's 1, 2 and 3 but not 4, or it could also be id's 2, 3 and 4 but not 1. I know how to do the sort in memory, but I don't want to fetch all the tables to memory, I want to qualify them at the DB level. Thanks Sigthor