Results 1 to 3 of 3

Thread: SQL query with 2 differenet table

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    VBAX Mentor
    Joined
    Feb 2012
    Posts
    406
    Location

    SQL query with 2 differenet table

    Hello , I have Table with this column


    • Table1 has columns (ID, Name, TEXTTYPE , LANGID) and sample data:
      (1, John, RB, 11),
      (2, Peter, PM, 12),
      (3, Mary, RB, 11)
      (4, Kristina, RB, 11)
    • Table2 has columns (TEXTTYPE , LANGID , Description, TRANSLATE) and sample data:
      (RB , 11, Apple, FR),
      (PM, 12, Apricot, GB),
      (RB , 14, Aubergine, TR),
      (PM, 12, Orange, FR),
      (RB, 11, Banana, GB)


    I need The below result only Show FR value in TRANSLATE column:

    (1, John, RB, 11 , Apple),
    (2, Peter, PM, 12, Orange),
    (3, Mary, RB, 11, Apple),
    (4, Kristina, RB, 11, Apple)

    I need this query for Oracle.
    Last edited by parscon; 07-09-2015 at 12:05 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
  •