SELECT EA7RECORDS.FIRSTNAME + ' ' + EA7RECORDS.LASTNAME as 'STUDENT NAME',
EA7RECORDS.USERDEFINEDID as 'STUDENT ID', EA7ATTRIBUTETYPES.DESCRIPTION as 'ATTRIBUTE DESCRIPTION', 
EA7STUDENTATTRIBUTES.LASTCHANGEDBYID, USERS.NAME as 'LAST CHANGED BY NAME', EA7STUDENTATTRIBUTES.DATECHANGED

FROM (EA7RECORDS 
INNER JOIN EA7STUDENTS ON EA7RECORDS.EA7RECORDSID = EA7STUDENTS.EA7RECORDSID) 
INNER JOIN (EA7STUDENTATTRIBUTES INNER JOIN EA7ATTRIBUTETYPES ON EA7STUDENTATTRIBUTES.ATTRIBUTETYPESID = EA7ATTRIBUTETYPES.ATTRIBUTETYPESID) ON EA7STUDENTS.EA7STUDENTSID = EA7STUDENTATTRIBUTES.PARENTID
LEFT OUTER JOIN USERS on EA7STUDENTATTRIBUTES.LASTCHANGEDBYID = USERS.USERSID

WHERE EA7RECORDS.USERDEFINEDID='1030' -- Drew Abernethy Student Id from sample data

Disclaimer: We provide programming examples for illustration only, without warranty either expressed or implied, including, but not limited to, the implied warranties of merchantability and/or fitness for a particular purpose. This article assumes you are familiar with Structured Query Language and the tools used to create and modify SQL statements and Crystal Reports. Our Customer Support may help explain the functionality of a particular procedure, but we will not modify, or assist you with modifying, these examples to provide additional functionality.