Dear all,

Can anyone give advice on my foxfire reporting tools?
I having problem in the sql join as following table.

Tables and their primary and foreign key.
------------------------------------------
Employee ID (Employee_ID PK, Religion_ID FK), such as employee records
Service History (Service_ID PK, Employee_ID FK), service department code, staff grading.
Religion (Religion_ID PK), religion code such as Christian, Catholic, others
Leave applications (Leave_ID PK, Employee_ID FK), daily leave records

Ps:
PK Primary Key
FK, Foreign Key


i generate the report base on all fields in all these 4 tables, but it crash.
Error message showing that the alias table "Religion" is not found.

Any advice? or need more details?
Thank you so much.