unfortunately that didn't seem to do it either. Same error message:
(DISPOSITION_TRANSACTION_SID = 923413) AND (PRIMARY_CONTACT_YRN = 'Y')
ERROR 000358: Invalid expression
Failed to execute (MakeTableView).
I altered my script to use the AddFieldDelimiter:
t1 = self.bcgw + '\\WHSE_TANTALIS.TA_TENANTS' # gobetween table
t2 = self.bcgw + '\\WHSE_TANTALIS.TA_INTERESTED_PARTIES'
# fields for joining the tables
t1Field = 'DISPOSITION_TRANSACTION_SID'
joinField = 'INTERESTED_PARTY_SID'
contField = 'PRIMARY_CONTACT_YRN'
# only pulling out client identified as "Primary Contact"
# editing out and trying AddFieldDelimiters
# http://desktop.arcgis.com/en/arcmap/latest/analyze/arcpy-functions/addfielddelimiters.htm
# whereClause = t1Field + " = " + str(dispID) + " AND \"PRIMARY_CONTACT_YRN\" = \'Y\'"
wcList = [t1Field, contField]
wc1 = arcpy.AddFieldDelimiters(self.bcgw, t1Field)
wc2 = arcpy.AddFieldDelimiters(self.bcgw, contField)
whereClause = "({0} = {1}) AND ({2} = '{3}')".format(wc1, str(dispID), wc2, 'Y')
arcpy.AddMessage(whereClause)
legal = 'LEGAL_NAME' # field names in the TA_INTERESTED_PARTIES table
first = 'FIRST_NAME'
last = 'LAST_NAME'
txtClientName = 'Interest Holder: ' # resetting txtClientName
arcpy.MakeTableView_management (t1, "t1View", whereClause)
arcpy.AddMessage("created t1View")