When using the method "CContact.GetContacts((IiMISUser)user, addlFrom, where.ToString(), sqlParam)", is it acceptable to add the "Gen_Tables" in the following manner?
String addlFrom = String.Empty; addlFrom = " INNER JOIN GHP_Company on Name.ID = GHP_Company.ID"; addlFrom = addlFrom + " INNER JOIN Gen_Tables ON GHP_Company.NAICS_1 = Gen_Tables.CODE"; StringBuilder where = new StringBuilder(); where.Append(" AND Name.ID = @ContactId"); where.Append(" AND Gen_Tables.TABLE_NAME = 'NAICS_DESCRIP'"); T don't get an error but, I'm not able to find the field "DESCRIPTION" from "Gen_Tables" in the results. I've tested this in sql to be sure that the field has a value. Any suggestions? Tom