Simple select

What is this statement missing ?

SELECT id FROM Cases WHERE Cases.tempcaselogid = CaseComments.tempcaselogid

I get this error:

Server: Msg 107, Level 16, State 3, Line 1
The column prefix 'CaseComments' does not match with a table name or alias
name used in the query.

I need to use "WHERE" and not a "JOIN"

Aleks

You need to include all tables (including CaseComments) in your FROM.