First of all, read my comment to the question.
Secondly...
If you really MUST to do it in T-SQL, you need to add number for each row (
MySQL ROW_NUMBER()[
^]) and then to use
CASE ... END[
^] statement, for example:
SET @row = 0;
SELECT RowNo, CASE WHEN RowNo =1 THEN music_id ELSE NULL END CASE AS music_id, CASE WHEN RowNo =1 THEN music_name ELSE NULL END CASE AS music_name, CASE WHEN RowNo =1 THEN music_image ELSE NULL END CASE AS music_image, Songtitle, Lyricist, Artist
FROM (
SELECT @row = @row +1 AS RowNo, t1.music_id, t1.movie_name AS music_name, t1.Movie_image AS music_image, t2.songtitle, t2.Lyricist, t2.Artist
FROM table1 AS t1 INNER JOIN table2 AS t2 ON t1.music_id = t2.music_id
) AS T