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!

Basic query help

Discussion in 'SQL PL/SQL' started by ishaikh, Sep 15, 2014.

  1. ishaikh

    ishaikh Guest

    I'm new to Oracle kindly help me, how to join two different tables and select statement to query data from both tables.
    Table one is WEATHER and table two is LOCATION.
    Regards
    ishaikh
     
  2. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Hi,

    Provide columns also...

    ex:

    select *
    from weather a
    ,location b
    where a.common_col=b.common_col
    ;
     
  3. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi Ishaikh,

    Please go through the following navigation link for the joins concept in SQL to join the multiple tables in single select statement.

    SQL Joins