1
SQL Table Join when the name of a column in Table1 equals the value of a column in Table2
Does anyone know how to write the SQL to join two DB2 tables when the name of Table1.columnA equals the data values stored in Table2.columnB? In the table structure examples listed below, I’m trying to figure out how to join Table1 and Table2 when the values in Table2.Tag_Name are equal to the column names in [...]
Answer Question
| November 3, 2009 8:13 AM
Conditional JOIN, Conditional SQL statements, Conditional statements, DB2 SQL, JOIN statement, SQL
Does anyone know how to write the SQL to join two DB2 tables when the name of Table1.columnA equals the data values stored in Table2.columnB? In the table structure examples listed below, I’m trying to figure out how to join Table1 and Table2 when the values in Table2.Tag_Name are equal to the column names in [...]
Answer Question
| November 3, 2009 8:13 AM
Conditional JOIN, Conditional SQL statements, Conditional statements, DB2 SQL, JOIN statement, SQL
1
