1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Query on joins

Discussion in 'SQL PL/SQL' started by Shanmugapriya, Oct 30, 2017.

  1. Shanmugapriya

    Shanmugapriya Active Member

    Messages:
    52
    Likes Received:
    0
    Trophy Points:
    130
    Location:
    Bangalore
    Hi,
    I have Table A and Table B with details as below.

    I need to basically get the missing term_no in Table A from Table B that lies between low_term and high_term of Table A

    Term_no low_term hi_term
    1 1 10
    2 1 10
    3 1 10
    4 1 10
    6 1 10
    8 1 10

    Table B with details

    Term_no
    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12

    I need output as

    Term_no
    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
     
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,531
    Likes Received:
    360
    Trophy Points:
    1,430
    Location:
    Aurora, CO