Joining Two Identical Custom SQL Statements Produces no Results in the Second Table

Published: 26 Jun 2020
Last Modified Date: 08 Jul 2022


When connecting to Amazon Redshift data using the Postgres connector, a custom SQL statement joined to an identical custom SQL statement will result in only null values for all fields in the right side of the join.


  • Tableau Desktop 2020.2.0
  • Amazon Redshift connection using the PostgreSQL connector


Option 1
Use the native Redshift connector for the data connection

Option 2
Give the join fields different aliases in the SQL statements

Option 3
Combine the two custom SQL statements into a single statement that also includes the join


This issue may be related to the driver used since it does not occur when Amazon Redshift connector is used instead of Postgres connector.
Did this article resolve the issue?