1 Reply Latest reply on Jul 22, 2013 5:45 PM by Dan Cory

    Join Filter vs Where Filter

    Stanley McLenna

      Is there a way to implement the same effect a JOIN clause has in Tableau vs a WHERE clause filter? For example, we have a table we'd like to filter in the JOIN clause so only the data that fits the criteria is joined to the other tables as compared. Our query looks like:

       

      JOIN "public"."mytable"

           ON mytable.columnaA = maintable.columnB

           ON mytable.columnaA = 'mystring'

       

      Based on the logs, every filter we put always puts that 'mystring' filter in the where clause. We get different results either way so how can we get the same effect as the filter above?