I am trying to create a query based on both artist and work of the artist.
For example :
If I use
select * from artist WHERE NAME::text ILIKE '%beethoven%'; it will return the list of artists whose name has “beethoven” as part of their name.
Also if I use
select * from work WHERE NAME::text ILIKE '%rammenta%'; this will return works which have “rammenta” as part of works name.
"Ah, rammenta", WoO 99 No. 6 is the work of
Ludwig van Beethoven . I need to get this complete work name and the corresponding artist name if a part of artist name and work name is given as input. Is it possible to query like this