alimozdemir · June 6, 2020 18:49
diff --git a/songs_view.sql b/songs_view.sql
 CREATE VIEW vw_Songs
 AS
    SELECT s.Id, s.Title, MIN(ISNULL(cs.[Status], 0) + 0) CountryStatus
    FROM Song AS s
        LEFT JOIN dbo.Country_Songs AS cs ON cs.SongId = s.Id
    GROUP BY s.Id, s.Title
	CREATE VIEW vw_Songs
	AS
	SELECT s.Id, s.Title, MIN(ISNULL(cs.[Status], 0) + 0) CountryStatus
	FROM Song AS s
	LEFT JOIN dbo.Country_Songs AS cs ON cs.SongId = s.Id
	GROUP BY s.Id, s.Title