8 Replies Latest reply on Aug 9, 2018 3:01 PM by Mark Johnson

    Custom SQL Query syntax question

    Mark Johnson

      Good afternoon community,

      Hopefully this is an easy answer for some SQL guru's.  (My knowledge of SQL is limited to simply being able to spell it)   

       

      I have 4 tables in a single Access DB file that will be feeding Tableau.  I would like to write a custom SQL query on the Data Source Tableau page that will Left Join Table 1 with Table 2, and also Left Join Table 3 with Table 4.  Then I want to Union the resulting T1/T2 Join with the resulting T3/T4 Join.

       

      a visual representation of what I am trying to do.  (the joins must happen first as the 2017 Location Reference Info is different than the 2018 Location Reference Info).

       

       

      Thanks in advance for any thoughts.