Help, I'm try to do this query : select * from CivilHeader where CivilHeader.CaseNumber = Judgment1.Casenumber but I get this error and dont know what is causing it : The column prefix 'Judgment1' does not match with a table name or alias name used in the query.

Judgment1 is a table not a column so the error message makes no sense