The column prefix does not match with a table name or alias name used in

[Matrix.net]

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

[Phil Weber]

You must include all tables referenced by the query in the FROM clause. Your FROM clause does not include a table named Judgment1, thus the error.

Try this:

SELECT * FROM CivilHeader, Judgment1
WHERE CivilHeader.CaseNumber = Judgment1.CaseNumber