SELECT LEFT(casemgmt_tmpsave.note,100) AS "First 100 chars of note", casemgmt_tmpsave.demographic_no,demographic.last_name,demographic.first_name, CONCAT(provider.last_name,",",provider.first_name) AS "Provider", CONCAT( "", "eChart", "" ) AS "eChart" FROM casemgmt_tmpsave LEFT JOIN demographic ON casemgmt_tmpsave.demographic_no = demographic.demographic_no LEFT JOIN provider ON casemgmt_tmpsave.provider_no = provider.provider_no ORDER BY casemgmt_tmpsave.provider_no;