select Album_2.*,User.UserName as userid from Album_2 left join User on Album_2.UserId=User.UserID
select a.Albumid,b.userName,a.GenreID,........from album_2 a ,User b where a.UserId=b.UserId
