Ergebnis der Suchanfrage

• Forum: Datenbanken

  Re: Ambiguous field names in firebird system tables

    Prism
    by shmia, 11. Okt 2006
  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:
  Mastertable.keyfield, ....,...