0 Replies Latest reply on Dec 22, 2017 7:11 AM by Kishor S

    Multiple left join in Tableau using custom SQL

    Kishor S

      I am trying to do multiple left join using custom SQL in Tableau 10 version. I am getting 'missing operator expression' error.

       

      Please find below syntax which I am trying: 

       

      select a.*, b.[Seg1], c.[Seg2] from [Base$] a left join

      ( select [REF_NO], first([Category]) as Seg1 from [Base2$] group by [REF_NO] ) b

      on a.[Account Number] = b.[REF_NO]

      left join

      ( select [REF_NO], first([CRE]) as Seg2 from [Base3$] group by [REF_NO] ) c

      on a.[Account Number] = c.[REF_NO]

       

       

      I am not able to find out what is missing operator in above syntax.

       

      Can anyone please help me out ?