1 2 Previous Next 15 Replies Latest reply on Sep 2, 2010 4:58 AM by Carmon Hesse

    Problem with aliases in TransformationEditor

    Carmon Hesse Newbie

      Hello everyone,

       

      Im using Teiid 7.0 and Teiid Designer 7.0 and I have the following SQL statement which is internally changed with the full-path variables:

       

      SELECT

           Product.ID AS id,

           Product.NAME AS ident,

           incomingProduct.ID AS incomingProductID

      FROM

           Product, Product AS incomingProduct

      WHERE

           Product.ID = incomingProduct.ID

       

      is changed to:


      SELECT
              model.Product.id AS id,
             
      model.Product.name AS ident,
               incomingProduct.
      model.Product.id AS incomingProductID
      FROM
             
      model.Product,
             
      model.Product AS incomingProduct
      WHERE
             
      model.Product.id = incomingProduct.model.Product.id

       

      As you can see in the changed SQL Statement instead of alias.column it is alias.model.table.column and the SQL is invalid.

      I've tried several approaches, with AS and without and it still doesn't work.

      Can you please help me out? Thanks for your time.

       

      Greetings,

      Carmon Hesse

       

      Message was edited by: Carmon Hesse Corrected thread name.

        1 2 Previous Next