Re: Is this SQL Possible??

use an analytical

select
c.name.c.assignment
from
(
select
a.name,b.assignment,row_number() over (partition by a.name order by b.assignment) rnum
from
employee a, gd b
where a.name = b.name
) c
where rnum = 1

--
http://www.freelists.org/webpage/oracle-l