Hi,
Can you post the select statement, without that I can only suggest a typo.
>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.
Regards N Mc Donald