> select name,address,max(userid) from insurance left join kic_member on [insurance].[id] = [kic_m
> ember].[userid] Group by name,address
>
오라클에서는 inner join 과 outer join 이 있는데
어떤 것이 Access의 left join 인지 모르겠네요.
제 생각에는 outer join 의 일종인 것 같습니다만...
일반적인 inner join 이라면
select name,address,max(userid)
from insurance , kic_member
where nsurance.id = kic_member.userid
Group by name,address
;
일반적인 outer join 이라면
select name,address,max(userid)
from insurance , kic_member
where insurance.id = kic_member.userid(+)
Group by name,address
;
또는
select name,address,max(userid)
from insurance , kic_member
where insurance.id(+) = kic_member.userid
Group by name,address
;
고생하시는군요.
|