Results 1 to 2 of 2
  1. #1
    raj reddy is offline Member
    Join Date
    Apr 2008
    Posts
    31
    Rep Power
    0

    Default Help In An Critical Query

    TABLE1 (TOTAL 3 COLUMNS)


    A B C







    TABLE2 (TOTAL 3 COLUMNS )


    D E F










    DESCRIPTION : actually there were two tables and of 3 columns containing each



    WHAT I NEED :


    I need a SINGLE query in such a way that





    I have to get all the values of TABLE2.F(column) where


    { TABLE1.C(column) [where i can hardcode this column value as "1"] = TABLE1.A(COLUMN)}



    and where TABLE1.A(COLUMN) /**ie this output { TABLE1.C(column) = TABLE1.A(COLUMN)} **/ = TABLE2.D(COLUMN)


    ANY DOUBTS REPLY TO ME

  2. #2
    rico16135 is offline Member
    Join Date
    Apr 2008
    Posts
    28
    Rep Power
    0

Similar Threads

  1. Replies: 1
    Last Post: 04-15-2008, 12:09 PM
  2. Replies: 0
    Last Post: 04-15-2008, 08:12 AM
  3. Help in Query
    By geeta_ravikanti in forum JDBC
    Replies: 0
    Last Post: 03-31-2008, 01:16 PM
  4. Using sql:query tag
    By Java Tip in forum Java Tip
    Replies: 0
    Last Post: 01-15-2008, 03:13 PM
  5. Using sql:query tag
    By Java Tip in forum Java Tip
    Replies: 0
    Last Post: 01-14-2008, 09:31 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
  •