1 Reply Latest reply on Jan 8, 2019 2:01 AM by Mahfooj Khan

    Selecting Specific columns for joining table

    Anthony Teng



      Would we be able to select only specific columns using the drag and drop option instead of using the custom query option.


      For instance, if we are implementing the query below:


      Select table1.a1, table1.a2, table2.b1

      from table1

      left join table2 on table1.e1=table2.e2


      I guess main issue is that each of my tables have a large number of columns each and not selecting for the columns that I wanted would sometime resulted in 'selecting too much columns' error.


      Thank you!