Thanks for the tip Kaz.  I just tried changing from all caps to all lowercase and then to capitalize each word, unfortunately nothing changed.  I suppose I can rule that out. 

*

Hi Tom,

Thanks for the reply. 

The Show Details of the error is "Firebird database error 335544396: column is not defined in table".

I tried cleaning up the table aliases and removing unnecessary syntax here and there, but that didn't work.  The SQL runs fine in FlameRobin.

Here's the SQL:

SELECT ARCHIVE_TRANSACTIONS_1.INS_CARRIER_CODE,

       ARCHIVE_TRANSACTIONS_1.PATNO,

       REGISTER_1.LNAME, REGISTER_1.FNAME,

       REGISTER_1.BIRTHDAT,

       ARCHIVE_TRANSACTIONS_1.INSURED_ID,

       ARCHIVE_TRANSACTIONS_1.DATE1,

       ARCHIVE_TRANSACTIONS_1.UPDATED1,

       ARCHIVE_TRANSACTIONS_1.TRNSXNO,

       ARCHIVE_TRANSACTIONS_1.CPTCODE,

       ARCHIVE_TRANSACTIONS_1.CPT_DESCRIPTION,

       ARCHIVE_TRANSACTIONS_1.DRINIT,

       ARCHIVE_TRANSACTIONS_1.CHARGE,

       ARCHIVE_TRANSACTIONS_1.TX_BALANCE,

       ARCHIVE_TRANSACTIONS_1.COPAYBALANCE,

       ARCHIVE_TRANSACTIONS_1.MEMO1,

       REGISTER_1.REFERDBY,

       ARCHIVE_TRANSACTIONS_1.INVOICENO,

       REGISTER_1.HPHONE, REGISTER_1.BPHONE,

       ARCHIVE_TRANSACTIONS_1.REND_ADDR_ID,

       DRLABEL_1.FNAME FNAME_2,

       DRLABEL_1.LNAME LNAME_2,

       INS_CARRIER_1.INS_CARRIER_NAME

FROM ARCHIVE_TRANSACTIONS ARCHIVE_TRANSACTIONS_1

      LEFT OUTER JOIN REGISTER REGISTER_1 ON

     (REGISTER_1.PATNO = ARCHIVE_TRANSACTIONS_1.PATNO)

      LEFT OUTER JOIN DRLABEL DRLABEL_1 ON

     (DRLABEL_1.ADDR_ID = ARCHIVE_TRANSACTIONS_1.REND_ADDR_ID)

      LEFT OUTER JOIN INS_CARRIER INS_CARRIER_1 ON

     (INS_CARRIER_1.INS_CARRIER_CODE = ARCHIVE_TRANSACTIONS_1.INS_CARRIER_CODE)

WHERE ( ARCHIVE_TRANSACTIONS_1.TXNOPAID < 1 )

       AND ( ARCHIVE_TRANSACTIONS_1.ARCHIVE_FLAG <= 1 )

       AND (( ARCHIVE_TRANSACTIONS_1.TX_BALANCE >= 0.01 )

       OR ( ARCHIVE_TRANSACTIONS_1.COPAYBALANCE >= 0.01 )

      ) AND ( ARCHIVE_TRANSACTIONS_1.PATNO > 0 )

Thanks for the tips!  I was able to trace it back to one column.  This column contains values that can be extremely long e.g.:

I wonder if that is causing the issue...

Thanks Tom.  Tried LEFT and although it works in FlameRobin it does not work in Tableau.  I will contact support.  You've been very helpful!

Tableau support helped me identify that the problem is because the field is a BLOB type which is unsupported by Tableau Desktop.  I was able to find syntax to convert the BLOB to a VARCHAR here: http://www.vdespa.de/blog/17-firebird-converting-blob-binary-column-in-string

Hope this helps someone else!