루디먼트

with cte_country as ( select name from country group by name ) select a.name, b.user_name from cte_country as a left outer join country as b on b.name = a.name and b.user = 'user1' ;


XE Login