SELECT TableA.*, TableB.*, TableC.*, TableD.*
FROM TableA
JOIN TableB
ON TableB.aID = TableA.aID
JOIN TableC
ON TableC.cID = TableB.cID
JOIN TableD
ON TableD.dID = TableA.dID
WHERE DATE(TableC.date)=date(now())
-----------------------------------------
SELECT Books_Namn, Author_Namn, Author_Age, Store_Namn FROM books
JOIN Author ON Author_Id = Author_Author_Id
JOIN Books_has_Store ON Books_Books_Id = Books_Id
JOIN Store ON Store_Id = Store_Store_Id;