I want to have the value of variable (say X) which is present in two Tables.
Both the tables have that column with same name. So i just want to know the variable value which is present in both the DB2 tables.
We tried with INNER JOIN but its giving the SQL Code -203
Please let me know the SQL query for this.
If u need more information do let me know.
If you are dealing with more then one table in your query it is better to qualify the column name with table name as the_gautam suggested. By this you can overcome the problems like -203(REFERENCE TO AN AMBIGUOUS COLUMN )