jquery - subquery returned more than 1 value in the following query

Question

I have a stored procedure that does a select * from book table, using a subquery.

My query is :

SELECT A.Titel, A.Preis
FROM Album A
WHERE A.Veroffentlichsdatum < (SELECT A.Veroffentlichsdatum
                               FROM Album A
                               INNER JOIN LiedAlbum ON LiedAlbum.IdAlbum = A.Id 
                                                    AND LiedAlbum.IdLied = (SELECT L.Id 
                                                                            FROM Lied L 
                                                                            WHERE L.Titel IN ('Lifeislife')))

What should I change to get rid of this error?

question from:https://stackoverflow.com/questions/65680117/subquery-returned-more-than-1-value-in-the-following-query

Answer 1

Not sure what you are trying to do. Since it is the same table why don't you just join them without subquery? The only modification right now I can suggest is the below :

LiedAlbum.IdLied =(SELECT L.Id from Lied L where L.Titel in ('Lifeislife'))

into

exists (select 1 from Lied where Titel = 'Lifeislife' and LiedAlbum.IdLied = Lied.Id)