MySQL Select Data from 5 Different Tables

I have to select data from 5 different tables. The main table is `Notices`. Following are the rows from the `Table Notices` which I want to select

SELECT * FROM `notices` WHERE notices.publication_date >'2020-03-01' and notices.publication_date < '2020-03-31'




Now I also have to select related information for these rows from different tables. Some tables have a direct relation with Table Notice and some tables are related via other tables.

My expected output is the following....

MySQL Select Data from 5 Different Tables

from Databases https://ift.tt/2XqpwDx
via IFTTT