I have two tabels :
`tbl_album` and `tbl_gallery`

How can I select the last image of the last three albums?

these are columns of my tables:

```
tbl_album:   Id,al_name
tbl_gallery: Id,album_id,ga_pic_title,ga_file_name

```

I use this query: 

```
select al.Id, al.al_name, ga.ga_file_name 
from tbl_album al inner join tbl_gallery ga 
on al.Id=ga.album_id  order by Id desc

```

I receive an error when I used Group By clause:

```
select al.Id, al.al_name, ga.ga_file_name 
from tbl_album al inner join tbl_gallery ga 
on al.Id=ga.album_id group by al.al_name order by Id desc

```

> 
> Msg 8120, Level 16, State 1, Line 1 Column 'tbl\_album.Id' is invalid
>  in the select list because it is not contained in either an aggregate
>  function or the GROUP BY clause.
> 
> 
> 

I do not want to repeat al\_name column.

Is there a better way?