SELECT col1, col2, col3, col4, col5, col6, col7 FROM T1, T2, T3 WHERE T1.col3value = T2.value AND T1.col4value = T3.value AND T1.col1 = some user supplied search value. For some reason I'm getting run time exceptions such as 'unknown column names' and 'ambiguous column names'. Tables T2 and T3 have exactly the same column names. I've seen solutions that resolve this by using a column map represented by a HashMap. I'm not sure how this would work and what the keys and values should be in this map.
I would appreciate some help with this, particularly a good example. Thanks.