For example, the following SQL code could be used to display the Fund Description, Fund Type, and Fund Category:

SELECT
FUND.DESCRIPTION,
FundType.LONGDESCRIPTION,
FundCat.LONGDESCRIPTION
FROM
FUND
LEFT OUTER JOIN TABLEENTRIES AS FundType ON FUND.FUNDTYPE = FundType.TABLEENTRIESID
LEFT OUTER JOIN TABLEENTRIES AS FundCat ON FUND.FUND_CATEGORY = FundCat.TABLEENTRIESID