SELECT...GROUP BY works to execute a view but not otherwise

Hi

I am trying to execute a SELECT Query in MSSQL Server 2008. This is our primary Database engine which runs on Windows Server 2003.

SELECT...GROUP BY Query:

SELECT Area FROM dbo.[Spool Numbers]

WHERE(JobNbr LIKE '17-0020%')

GROUP BY Area;

The error I am receiving follows:

Msg 208, Level 16, State 1, Line 1 Invalid object name 'dbo.Spool Numbers'.

I left out the 'dbo' at a point in time and got the same error (Excluding the dbo.). I don't understand the error because it worked fine when I tried a 'View'.

I got the results I needed.

I am fairly new to working on real databases. I've only came across errors at school.

How can I resolve this? Also if you can guide me to training, that will be great! The more I learn the better.