I have 4 tables with the following relationship. Table_3 is the central table of the star schema. How to write a sql to join these 4 tables ? The difficult thing is how to join table_1 with table_2 ? Do I have to use sub-query (nested join ) ?I have 4 tables with the following relationship