I have the following TitleDetailsRequest table: see TitleDetailsRequest.jpg attachment.
I need to get an output of the EN_No and FR_No for all the Stores and for all the titles Title based on the latest RequestDate as follow: see TitleDetailsRequest_Output.jpg attachment.
The Title table have all the titles that need to be in the output, so if a title is not in the TitleDetailsRequest table (i.e. Title3) the output should just display "0". Currently there are 30 titles in the Title table but the users can add new titles so hardcoding the titles into columns will not be an option considering that the users can also add new titles.
Your help with regards to this matter will be greatly appreciated.