Ambiguous field names in firebird system tables

[shmia]

Example:
SELECT * FROM Mastertable INNER JOIN DetailTable ON MasterTable.keyfield=DetailTable.keyfield You get all fields from both table as the result set.
Problem: there are 2 fields with the same name ("keyfield")
These fields are called ambiguous fields.
It depends on the DBMS how this conflict is solved. Some databases add the tablename as prefix:

Code:

Mastertable.keyfield, ...., DetailTable.keyfield

Other databases simply throw a error message.
You should show your complete SQL-Statement