This is my query:

```
SELECT a.vardas, a.pavarde FROM `y6fdt_igym_abonementai` AS a 
INNER JOIN 
( 
    SELECT max(galiojaiki) gal, id, abonementas FROm y6fdt_igym_sutartys
) c
on c.abonementas = a.id

```

Why I see only a.vardas and a.pavarde columns as result. But not id, abonementas from subquery ?