Load Ingest Data
Results 1 to 2 of 2

Thread: XADatasource - Join query on tables with same column name

  1. #1
    vijay_3103 is offline Junior Member
    Join Date
    Sep 2006
    Rep Power

    XADatasource - Join query on tables with same column name

    select A.refno, name, B.prodid,suffix from
    table1 as A, table2 as B.table3 as C
    A.refno = B.refno
    and A.prodid = C.prodid.
    All tables A B and C have a column by the same name prodid.
    This query directly works when executed on the db.

    But, when I execute the same through Java code using AttunityXADatasource it throws an error saying cannot find column A.prodid doesnt exist.
    I tried replacing the prefix with the actual table names and still it doesnt work.

    Can anyone help on this please.

  2. #2
    Boaz Newman is offline Support
    Join Date
    Aug 2006
    Rep Power
    We would like to reproduce your issue, we where unable to do it with 3 simple tables, can you please supply the metadata of the 3 tables that you used.
    To Find Out more About Attunity Technology:
    Contact Us

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts