Cacher is the code snippet organizer for pro developers

with a  as (
  select relnr from dpers
  ),
  b as (
    select relnr, geslacht from dpers
   )
  
select * from a join b on a.relnr=b.relnr limit 10