Results 1 to 2 of 2
  1. #1
    Daredemo is offline Member
    Join Date
    Jul 2008
    Posts
    3
    Rep Power
    0

    Default 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:

    viewABC
    ----------
    nameA
    nameB
    x
    y

    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.

  2. #2
    Eranga's Avatar
    Eranga is offline Moderator
    Join Date
    Jul 2007
    Location
    Colombo, Sri Lanka
    Posts
    11,371
    Blog Entries
    1
    Rep Power
    20

Similar Threads

  1. Query in database
    By anki1234 in forum JDBC
    Replies: 3
    Last Post: 08-20-2008, 06:45 PM
  2. Help in Query
    By geeta_ravikanti in forum JDBC
    Replies: 0
    Last Post: 03-31-2008, 02:16 PM
  3. Using sql:query tag
    By Java Tip in forum Java Tip
    Replies: 0
    Last Post: 01-15-2008, 04:13 PM
  4. Using sql:query tag
    By Java Tip in forum Java Tip
    Replies: 0
    Last Post: 01-14-2008, 10:31 AM
  5. reset query
    By dd_verni in forum JDBC
    Replies: 0
    Last Post: 11-21-2007, 04:52 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •