>>>I'm trying to create a View in SQL 2000 from/for a TimeClock database that will select the last record for employees (that aren't currently clocked in)
>>>
>>>Here is a Select statement and the data below is returned:
>>>
>>>

>>>SELECT     TOP 100 PERCENT dbo.EmployeeHours.EmployeeId, dbo.EmployeeHours.TimeIn, dbo.EmployeeHours.TimeOut, dbo.EmployeeHours.JobCode, 
>>>                      dbo.MasterJobCodeList.Description, dbo.EmployeeHours.CostCode
>>>FROM         dbo.EmployeeHours INNER JOIN
>>>                      dbo.MasterCostCodeList ON dbo.EmployeeHours.CostCode = dbo.MasterCostCodeList.Level1 INNER JOIN
>>>                      dbo.MasterJobCodeList ON dbo.EmployeeHours.JobCode = dbo.MasterJobCodeList.JobCode
>>>WHERE     (dbo.MasterCostCodeList.Active = 1) AND (NOT (dbo.EmployeeHours.TimeOut IS NULL))
>>>ORDER BY dbo.EmployeeHours.TimeIn DESC
>>>

>>>
>>>

>>>EmpID	timeIn	TimeOut	JobCode	Description	CostCode
>>>118	8/14/2013 6:59	8/14/2013 7:02	3	Jobs	18725
>>>133	8/14/2013 6:59	8/14/2013 8:11	2	Drafting	18871
>>>72	8/14/2013 6:58	8/14/2013 8:20	3	Jobs	17819
>>>10	8/14/2013 6:57	8/14/2013 8:04	10	Laser	18860
>>>10	8/14/2013 6:52	8/14/2013 6:57	10	Laser	18861
>>>8	8/14/2013 6:46	8/14/2013 8:00	2	Drafting	18658
>>>115	8/14/2013 6:44	8/14/2013 7:18	3	Jobs	18886
>>>122	8/14/2013 6:44	8/14/2013 7:10	3	Jobs	16112
>>>47	8/13/2013 16:08	8/13/2013 16:30	3	Jobs	18748
>>>122	8/13/2013 15:33	8/13/2013 16:42	10	Laser	16112
>>>10	8/13/2013 15:18	8/13/2013 15:42	10	Laser	18658
>>>122	8/13/2013 15:17	8/13/2013 15:33	3	Jobs	16112
>>>122	8/13/2013 15:13	8/13/2013 15:17	10	Laser	16112
>>>47	8/13/2013 15:11	8/13/2013 16:08	3	Jobs	18905
>>>7	8/13/2013 15:09	8/13/2013 16:33	3	Jobs	18833
>>>34	8/13/2013 15:04	8/13/2013 16:22	2	Drafting	18903
>>>7	8/13/2013 15:04	8/13/2013 15:09	3	Jobs	18658
>>>

>>>
>>>How would one go about retrieving the last record for each EmpID and returning only one record for each EmpID?
>>>
>>>I hope I explained that clearly.
>>
>>
>>

>>SELECT dbo.EmployeeHours.EmployeeId,
>>       dbo.EmployeeHours.TimeIn,
>>       dbo.EmployeeHours.TimeOut,
>>       dbo.EmployeeHours.JobCode, 
>>       dbo.MasterJobCodeList.Description,
>>       dbo.EmployeeHours.CostCode
>>FROM dbo.EmployeeHours
>>INNER JOIN dbo.MasterCostCodeList ON dbo.EmployeeHours.CostCode = dbo.MasterCostCodeList.Level1
>>INNER JOIN dbo.MasterJobCodeList ON dbo.EmployeeHours.JobCode = dbo.MasterJobCodeList.JobCode
>>INNER JOIN (SELECT EmployeeId,
>>                  MAX(TimeIn) AS TimeIn
>>            FROM dbo.EmployeeHours
>>            GROUP BY EmployeeId)<b> EmplMax</b>
>>      ON EmplMax.EmployeeId dbo.EmployeeHours.EmployeeId
>>     AND EmplMax.TimeIn = dbo.EmployeeHours.TimeIn
>>WHERE dbo.MasterCostCodeList.Active = 1
>>  AND NOT dbo.EmployeeHours.TimeOut IS NULL
>>ORDER BY dbo.EmployeeHours.TimeIn DESC
>>

>
>I think I'm understanding where your going with this but I'm getting an error
>

>Server: Msg 170, Level 15, State 1, Line 14
>Line 14: Incorrect syntax near 'dbo'.
>

>and I can't figure out the syntax.

 ON EmplMax.EmployeeId = dbo.EmployeeHours.EmployeeId -- missed equal sign here