SQL Join challenge

From: Steven Helms (steve_at_sh3inc.com)
Date: 10/28/03 

Date: Tue, 28 Oct 2003 13:18:10 -0500

I have the following, but it does not work. It works with one inner join
statement. I want the end result to be the complete LOG table and the
AppraiserName, AppraisalType and ReportType columns. Can anyone help with
this Join?

SELECT LOG.*,
FROM LOG
Appraisers.FULLNAME AS AppraiserName,
AppraisalType.DESC AS AppraisalType,
ReportType.DESC AS ReportType
FROM (((Log
INNER JOIN Appraisers ON Log.APPRAISER = Appraisers.APPRAISERINITIALS)
INNER JOIN ApraisalType ON LOG.APPRAISAL_TYPE =
AppraisalType.APPRAISAL_TYPE)
INNER JOIN ReportType ON LOG.REPORT_TYPE = ReportType.REPORT_TYPE)
WHERE ((LOG.APPRAISAL_NUMBER)=9987)

Thank you,
Steven