If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

How do I get the group by function to return the first record like the first query. I was hoping the results would be:
+-----------------+----------------+------------+-----------+
| PROPOSAL_NUMBER | UNITERM_NUMBER | FIRST_NAME | LAST_NAME |
+-----------------+----------------+------------+-----------+
| 12098 | 12987 | John | Doe |
+-----------------+----------------+------------+-----------+

If I need to explain any other items please let me know. I have spent the last 8 hours trying to find a solution and have yet to find one. So here I am at the forums Might a subquery help? I have never used a subquery before.