I want to join the following three tables where my condition is t1.eid = 1. After joining the tables I want to fill the empty table cell with 0. I have think to join first t1 with t2 where t1.eid=1 and then joining the result with t3 where the result of the two tables with t3 where t3.vid= the new result.vid.I want to join the following three tables where