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!

What is difference between inner join and normal join query.......!!!!

Discussion in 'SQL PL/SQL' started by ankit.mca.aaidu, Oct 1, 2013.

  1. ankit.mca.aaidu

    ankit.mca.aaidu Active Member

    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    55
    Location:
    Pune
    Code (Text):

    select * from orders  inner join part ON orders.partnum= part.partnum
     
    [TABLE]
    ORDERDON NAME PARTNUM QUANTITY REMARKS PARTNUM DESCRIPTION PRICE
    15-MAY-96 TRUE WHEEL 23 6 PAID 23 MOUNTAIN 350.45
    19-MAY-96 TRUE WHEEL 76 3 PAID 76 ROAD BIKE 530.00
    02-SEP-96 TRUE WHEEL 10 1 PAID 10 TANDEM 1200.00
    30-JUN-96 TRUE WHEEL 42 8 PAID 42 SEATS 24.50
    30-JUN-96 BIKE SPEC 54 10 PAID 54 PEDALS 54.24
    30-MAY-96 BIKE SPEC 10 2 PAID 10 TANDEM 1200.00
    30-MAY-96 BIKE SPEC 23 8 PAID 23 MOUNTAIN 350.45
    17-JAN-96 BIKE SPEC 76 11 PAID 76 ROAD BIKE 530.00
    17-JAN-96 LE SHOPPE 76 5 PAID 76 ROAD BIKE 530.00
    01-JUN-96 LE SHOPPE 10 3 PAID 10 TANDEM 1200.00
    01-JUN-96 AAA BIKE 10 1 PAID 10 TANDEM 1200.00
    01-JUL-96 AAA BIKE 76 4 PAID 76 ROAD BIKE 530.00
    01-JUL-96 AAA BIKE 46 14 PAID 46 TIRES 15.25
    11-JUL-96 JACKS BIKE 76 14 PAID 76 ROAD BIKE 530.00
    [/TABLE]

    Code (Text):

    select * from part p , orders o where o.partnum = p.partnum
     
    [TABLE]
    PARTNUM DESCRIPTION PRICE ORDERDON NAME PARTNUM QUANTITY REMARKS
    23 MOUNTAIN 350.45 15-MAY-96 TRUE WHEEL 23 6 PAID
    76 ROAD BIKE 530.00 19-MAY-96 TRUE WHEEL 76 3 PAID
    10 TANDEM 1200.00 02-SEP-96 TRUE WHEEL 10 1 PAID
    42 SEATS 24.50 30-JUN-96 TRUE WHEEL 42 8 PAID
    54 PEDALS 54.24 30-JUN-96 BIKE SPEC 54 10 PAID
    10 TANDEM 1200.00 30-MAY-96 BIKE SPEC 10 2 PAID
    23 MOUNTAIN 350.45 30-MAY-96 BIKE SPEC 23 8 PAID
    76 ROAD BIKE 530.00 17-JAN-96 BIKE SPEC 76 11 PAID
    76 ROAD BIKE 530.00 17-JAN-96 LE SHOPPE 76 5 PAID
    10 TANDEM 1200.00 01-JUN-96 LE SHOPPE 10 3 PAID
    10 TANDEM 1200.00 01-JUN-96 AAA BIKE 10 1 PAID
    76 ROAD BIKE 530.00 01-JUL-96 AAA BIKE 76 4 PAID
    46 TIRES 15.25 01-JUL-96 AAA BIKE 46 14 PAID
    76 ROAD BIKE 530.00 11-JUL-96 JACKS BIKE 76 14 PAID
    [/TABLE]

     
  2. prashant

    prashant Forum Advisor

    Messages:
    85
    Likes Received:
    7
    Trophy Points:
    160
    Location:
    New Delhi, India
  3. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
  4. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,347
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO