We are using a TIBOQuery for the update of the table LAB_
UNIDADESMEDIDAS using this Query:


SELECT UME.*
, UME2.UME_NOMBRE
, UMG_NOMBRE
FROM LAB_UNIDADESMEDIDAS UME
LEFT JOIN LAB_UNIDADESMEDIDAS UME2 ON (UME2.UME_ID = UME.UME_
REFERENCIA)
LEFT JOIN LAB_UNIDADESMEDIDASGRUPO ON (UME.UME_GRUPO = UMG_ID)

with Keylinks = UME_ID

But when opening we get this error:

"Ambiguos field name between table LAB_UNIDADESMEDICAS
and table LAB_UNIDADESMEDICAS UME_ID"

The problem is that we are using two references to the same table LAB_
UNIDADESMEDIDAS but with different aliases for each one... UME and UME
2

alredy try using UME.UME_ID in the KeyLinks, and naming the UpdateSQL
Table with the Alias but the porblem persists...

How must we configure the IBOQuery to avoid this error????

Thanx in advance