Using Sub Query with INNER JOIN in SQL Server

hi,

I am trying to get Top 1 FilePath from my Images table in addition

to an Inner Join statement that works.

working SQL statement

 returns records from 2 tables where approved = 1

            using (SqlCommand cmd = new SqlCommand("SELECT a.StageName,l.City,l.latitude,l.longitude,l.Url FROM PlayMeArtist a INNER JOIN PlayMeLocation l ON a.ArtistId = l.ArtistId WHERE a.Approved = 1", con))

not working

 I have now added a subselect to get TOP 1 image

from Images table in adddition to the above Query whats working.

but I get an errror which indicates Statement is not setup correct

 {
            using (SqlCommand cmd = new SqlCommand("SELECT a.Name,l.City,l.latitude,l.longitude,l.Url,  (SELECT TOP 1 FilePath FROM Images WHERE (ArtistId = Location.ArtistId)) As ImagePath FROM PlayMeArtist a INNER JOIN PlayMeLocation l ON a.ArtistId = l.ArtistId WHERE a.Approved = 1", con))

thank you for any examples how to do this.?