2 Replies Latest reply on Mar 31, 2010 9:47 AM by fred29

    Trouble with insert/select query via ODBC and IDauto

    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