need a help to retrieve data from 2 diif table

5 pts.
Tags:
Oracle proprietary joins
we have 2 tables where only 1 column data available for comparison and also returns more than 1 row what to do 


Software/Hardware used:
sql developer
Asked: Last updated:
1

Answer Wiki

Thanks. We'll let you know when a new response is added.

Have you tried the DISTINCT keyword?

Discuss This Question: 5  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • TheRealRaven
    What to do will depend on what result you need. Why does it matter if a query "returns more than 1 row"? That's very common. If more than one row results, what are you wanting to happen?

    Showing a few examples from the tables, along with the result that you want, will help us know how to respond.
    32,460 pointsBadges:
    report
  • Subhendu Sen
    Have you written some codes? What error is there? Please come with your code that can be helpful to get reply quickly.
    130,690 pointsBadges:
    report
  • ToddN2000
    Post the code you have tried so we can get a better understanding of the tables and columns in question. If you are looking for just one returned row, is it solely on the join column? If so then use DISTINCT like Splat mentioned, If it by more that one column then you need the GROUP BY.  Without seeing what you have this is my best guess. 
    125,970 pointsBadges:
    report
  • Subhendu Sen
    Please check here for more help, https://www.tutorialspoint.com/sql_certificate/get_data_from_multiple_tables.htm
    130,690 pointsBadges:
    report
  • ToddN2000
    Post your code and we can show you how to correct it. It is not a difficult task. We are glad to help you figure out your issue but trying it helps reinforce the knowledge. 
    125,970 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: