I need help with a query.
In my application, I have three tables from which I created a view, lets call them table A, B and C. I have a frame in which the user inputs a search word into a textfield, this word is from the column 'name' from table A.
I need to return the values from the column 'name' from table B associated with two columns (x and y, lets say) from from table C. These columns are organized in a view in the following manner:
How would I pick up the values I want from the ResultSet? I was thinking of using a Vector to store the values, then get the values from the Vector to populate a table with the result.