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!

Sql joins doubt

Discussion in 'SQL PL/SQL' started by manikantaspm, Jan 8, 2018.

  1. manikantaspm

    manikantaspm Starter

    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    10
    Location:
    rajahmundry
    help me joins between hz_parties and
    HZ_PARTY_USAGES_VL
     
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,637
    Likes Received:
    368
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    I don't know where to begin, and no one else does, either. You failed to provide any useful information for this question.

    Provide table definitions and MAYBE someone can assist you.
     
  3. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,750
    Likes Received:
    148
    Trophy Points:
    1,805
    Location:
    Redondo Beach, California
    What's the exact requirement you are looking for ? Why you want to join these 2 tables ?
    I don't see any direct joins between these two tables.
     
  4. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,637
    Likes Received:
    368
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    There is no way to join those two tables -- there is no common column between them.