Showing info from differnt tables

Hi, I cannot get this done  properly Material     Material type   Sales     Material Description   Material Type   date material Value 123 BLUE BIKE   123 BIKE   03-Ju...