query help2
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: query help2

  1. #1
    Join Date
    Apr 2002
    Posts
    135

    query help2

    hia

    I have a table

    stuid name age sex
    1 deepa 23 F
    2 indu 22 F
    3 Prem 25 M
    4 Pri 22 F

    Another table
    A B
    1 2
    3 4

    i need an output as following

    1 deepa 2 indu
    3 prem 4 pri
    Good Judgement comes from Experience.
    Experience comes from Bad Judgement

  2. #2
    Join Date
    Apr 2001
    Location
    Czechia
    Posts
    712
    Hi.
    Code:
    select the_table1.stuid, the_table1.name, the_table2.stuid, the_table2.name
      from the_table the_table1, the_table the_table2, another_table
     where the_table1.stuid = another_table.A
       and the_table2.stuid = another_table.B
    Ales
    The whole difference between a little boy and an adult man is the price of toys

Posting Permissions

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



Click Here to Expand Forum to Full Width