Table names do not match. The table referenced in the qualified field name must match the table referenced in the SELECT ...