join multiple tables sql
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())
Source: stackoverflow.com
join multiple tables in sql
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;