SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE dbo.songs_not_in_albums @x int
AS
BEGIN
  SELECT DISTINCT groups.group_name, people.surname, 
        people.[name], people.patronymic, compositions.composition_name
  FROM groups, people, compositions, repertoire, link
  WHERE repertoire.artist_group_fk = @x 
    AND link.id = repertoire.artist_group_fk 
    AND link.id = people.man_id  
        AND compositions.composition_id = repertoire.composition_fk
    AND repertoire.album_fk IS NULL;
END