4 Replies Latest reply on Dec 12, 2016 8:39 AM by Konstantinos Drosatos

    "Column ambiguously defined" ... not really!

    Mike DLoss

      Ok, so I'm trying to run a custom SQL query for a data connection, something like this:

       

      select col1, col1, col2 from usertest1, usertest2

       

      Both of these tables have both of these columns. And when previewing results, it gives me this error Oracle database error 918: ORA-00918: column ambiguously defined. Ok, I get that, the error makes sense.

       

      But now, when I try this query:

       

      select usertest1.col1, usertest2.col1, usertest2.col2 from usertest1, usertest2

       

      I am still receiving this error: Oracle database error 918: ORA-00918: column ambiguously defined.

       

      Anyone have insight as to why this is happening and how I can avoid it?