AnsweredAssumed Answered

Trouble with insert/select query via ODBC and IDauto

Question asked by fred29 on Mar 31, 2010
Latest reply on Mar 31, 2010 by fred29

Title

Trouble with insert/select query via ODBC and IDauto

Post

Hi,

 

I'm trying to execute the following query via ODBC on a filemaker pro 11 DB :

insert into I_BOOK
(Familia, IDTipoEtiqueta)
select  
        DIS
.IDAuto Familia,
        TE
.IDAuto IDTipoEtiqueta
from
        DIS_Colecciones_Etiquetado AS DIS
, DIS_Tipos_Etiquetas AS TE, TMP_LABEL AS LAB
where   (1=1)
 
And (LAB.TIPO_COLECCION=DIS.NombreCol)
AND
(LAB.PRODUCTTYPE=TE.NombreTipoPDM)

 

But when I execute the query I have the following error message whereas the select alone runs without error :

 

FQL0006/(4:2): The column named "IDAuto" appears in more than one table in the column reference's scope.

Any idea ?

 

Thanks

 

 

 

Outcomes