select sphp.ATTVALUE as HOMEPAGEDEF, us.USVORNAME, us.USFAMILIENNAME

  from CCUS us

    left outer join CCATT sphp on sphp.ATTPARKURZ=us.USKURZZ and sphp.ATTARCHTYP='SESSPREF' and sphp.ATTPARTYPE='CCUS' and sphp.ATTNAME='HOMEPAGEDEF'

 where us.USKURZZ=::uskurzz::