This content has been marked as final. Show 5 replies
I have an issue which I hope you can help me with. I have a straight table where one column is an ISBN number which is a specific code for a book. In the expression I have count of listenings to the specific books. The issue is that I want to filter ISBN number which have a specific serie (where 4 numbers in the ISBN number are the same) I have added below code in the script but I guess I have to add an expression aswell in the table?
select p.ID as PROGRAM_ID, p.ISBN, p.NAME, roy.ID AS ROYALTY_ID, roy.CUSTOMER_ID, roy.FULL_EQUIVALENTS, roy.INSERT_DATE AS INSERT_DATE
FROM bokilur.ROYALTY_DK roy
JOIN bokilur.PROGRAM p ON roy.PROGRAM_ID=p.ID
WHERE PUBLISHER LIKE '%Gyldendal%' AND ISBN LIKE '%0215%'