/*
Tabelle »public.directory_guest«
Spalte                 |          Typ           |                            Attribute
-----------------------+------------------------+-----------------------------------------------------
id                     | integer                | not null
first_name             | character varying(100) | not null
last_name              | character varying(100) | not null
*/

/*
Tabelle »public.directory_guest_years«
Spalte  |   Typ   |                               Attribute
----------+---------+------------------------------------------------------------------------
id       | integer | not null
guest_id | integer | not null
years_id | integer | not null

*/


/*
Tabelle »public.directory_years«
Spalte |   Typ   |                            Attribute
--------+---------+------------------------------------------------------------------
id     | integer | not null
years  | integer | not null
*/

SELECT  public.directory_guest.id,
        public.directory_guest.first_name,
        public.directory_guest.last_name,
        public.directory_years.years

FROM public.directory_guest

INNER JOIN public.directory_guest_years
    ON public.directory_guest.id=public.directory_guest_years.guest_id

INNER JOIN public.directory_years
    ON public.directory_guest_years.years_id=public.directory_years.id

GROUP BY    public.directory_guest.id,
            public.directory_guest.first_name,
            public.directory_guest.last_name,
            public.directory_years.years
HAVING MIN(public.directory_years.years)>0

ORDER BY public.directory_guest.id