UrbanPro
Login Ask & Answer Success Stories Paid Courses Free Classes Tuition & Classes Fees Write a Review All Categories Help Center
Post your Learning Need Signup as a Tutor
✕

Popular Cities

Bangalore

Hyderabad

Delhi

Mumbai

Chennai

Pune

Kolkata

Gurgaon

Ahmedabad

Jaipur

Noida

✕

Learn Computer Software from the Best Tutors

  • Affordable fees
  • 1-1 or Group class
  • Flexible Timings
  • Verified Tutors

Book a Free Demo

Computer Software > Learn Computer Software > I have 3 tables as - TASK, TASK_EFFORT and TASk_ROLE...
✕

Search in

I have 3 tables as - TASK, TASK_EFFORT and TASk_ROLE as follows in ORACLE database.: TASK TASK_EFFORT TASk_ROLE TASK_ID TASK_ID TASK_EFFORT_ID TASK_ID TASK_ROLE-ID t1 t1 e1 t1 r1 t1 e2 t1 r2 t2 t2 e3 t2 r3 t2 e4 t2 r4 I need the ouput Result set as : r1 t1 e1 r2 t1 e2 r3 t2 e3 r4 t2 e4 When I tried doing the same using inner join - I got the following ouput . Please let me know the query to get the above correct result. r1 t1 e1 r1 t1 e2 r2 t1 e1 r2 t1 e2 r3 t2 e3 r3 t2 e4 r4 t2 e3 r4 t2 e4

Asked by Last Modified  

8 Answers

Learn Computer Software

Follow 0
Answer

Please enter your answer

Educate! Being smart is great!!!

You can try the below query. sorry for delayed response SELECT DISTINCT RO.TASK_ROLE_ID, TA.TASK_ID, EF.TASK_EFFORT_ID FROM TASK TA INNER JOIN TASK_EFFORT_ID EF ON EF.TASK_ID = TA.TASK_ID INNER JOIN TASK_ROLE RO ON RO.TASK_ID=TA.TASK_ID ORDER BY RO.TASK_ROLE_ID
Comments
Dislike Bookmark

Trainer

Select tr.TASK_ROLE-ID, ta.TASK_ID, te.TASK_EFFORT_ID from TASK ta inner join TASK_EFFORT_ID te on te.TASK_ID=ta.TASK_ID inner join TASK_ROLE tr on trTASK_ID=ta.TASK_ID
Comments
Dislike Bookmark

Trainer

Can you please probvide the table data clearly, I have taken it once column value is missing. Please share the question in better way. You can refer the below query and try: Select tr.TASK_ROLE-ID, ta.TASK_ID, te.TASK_EFFORT_ID from TASK ta inner join TASK_EFFORT_ID te on te.TASK_ID=ta.TASK_ID inner...
read more
Can you please probvide the table data clearly, I have taken it once column value is missing. Please share the question in better way. You can refer the below query and try: Select tr.TASK_ROLE-ID, ta.TASK_ID, te.TASK_EFFORT_ID from TASK ta inner join TASK_EFFORT_ID te on te.TASK_ID=ta.TASK_ID inner join TASK_ROLE tr on trTASK_ID=ta.TASK_ID read less
Comments
Dislike Bookmark

bcom and diploma incomputer hardware networking

r4 t2 e4
Comments
Dislike Bookmark

Oracle, Hindi, C++, C, MS Office, VBScript,JavaScript,Spoken English etc with 29 years of experience

Select tr.TASK_ROLE-ID, ta.TASK_ID, te.TASK_EFFORT_ID from TASK ta inner join TASK_EFFORT_ID te on te.TASK_ID=ta.TASK_ID inner join TASK_ROLE tr on trTASK_ID=ta.TASK_ID;
Comments
Dislike Bookmark

Experienced tutor for school kids till class 10 all subjects

Can you give your table and its corresponding values a bit more clear?
Comments
Dislike Bookmark

Jitendra, can you please share your query which is giving you wrong result?... you can get somehelp here to reach to solution.. not the readymade solution.
Comments
Dislike Bookmark

Selenium WebDriver

The Query which you given won't work like that ... What you are mentioned is just a inner query .. for that you will get the out put which I had mentioned in the last section of my question...! But I need the output only I need the ouput Result set as : r1 t1 e1 r2 t1 e2 r3 t2 e3 r4 t2 e4 -
Comments
Dislike Bookmark

View 6 more Answers

Related Questions

What is the difference between Paste and Paste Special Option in Excel?
Paste: Paste all values, formats, formulas, comments, etc. Paste special: Paste with option, only values, only values, only formats, etc or all.
Vijayalakshmi G M
what is java core language?
Java is of 3 types - core java, java EE, Java ME Core java is used to develop application windows specific where Java EE is used for web applications and Java ME is used for mobile applications.
Md
0 0
9
I want to learn swift programming language ,pl advise
If you are a fresher and wants to get into iOS apps developement , you must know OOPs and Objective-C .. Suppose if you get into any Company and they give old application which was written in Objective-C...
Satyaraju
0 0
7
which course do u suggest me to do to get placed in IT. Im a 2008 graduate.
Definitely any of the programming languages. To the most of it, learn generic skills most common to all of those in the market.. Whether Java, DotNet whatever. Master the frameworks in it.
David
How much of ADF Faces we should know to effectively work in Oracle ADF? I am a beginner and looking for some guidance and training on working on projects on Fusion Apps.
Basics is enough, plus it depends on project. Creating a page, navigation using TFs, commit an operation etc. and knowledge on layout components is a big plus. Best part of ADF is ADF BC feature.
Jalil
0 0
6

Now ask question in any of the 1000+ Categories, and get Answers from Tutors and Trainers on UrbanPro.com

Ask a Question

Related Lessons

C and C++ programming with memory level debugging
Understanding C and C++ programming by using memory level debugging. Step 1: Understand the Memory map of C executable Step 2: Start memory level debugging using popular IDE Step 3: Find the memory...

Umasankar Natarajan

0 0
0
GIT
In software engineering, software configuration management (SCM) is the task of tracking and controlling changes in the software, part of the larger cross-disciplinary field of configuration management....
R

Rahul Kumar

0 0
0
What is Framework?
In computer programming, a software framework is an abstraction in which software providing generic functionality can be selectively changed by additional user-written code, thus providing application-specific...

Vinay Maurya

0 0
0
Focus on Fundamentals
It is very important to focus on fundamentals of any subject one is interested to gain command over that subject. If one learns and understand the fundamentals throughly, it is easy to grasp the advance...

Vihanga EmbedSoft

0 0
0
The ABCs Of Success For A Software Developer
“There is more to know for career advancement rather than focusing on codes and its challenges to become a successful developer”. A developer is the one who creates software application by...

Mercury Solutions limited

0 0
0

Recommended Articles

MCTS certification course in India

MCTS Certification in India The Microsoft Certified Technology Specialist or MCTS certification is suited for professionals who want to get into profession of implementing, building, troubleshooting, and debugging a particular Microsoft technology. The MCTS certification can give you a clear edge over others to showcase...

Read full article >

10 Keyboard Shortcuts to Get Rid Off The Mouse

Whether you are using a laptop or a desktop, the mouse surely takes up time. Imagine if you could alone manage with the keys and not have to move your hands around the mouse? That would have been faster and so much time-saving. For example, Control + Z for undo or Control + Y for redo, definitely saves time when we are...

Read full article >

10 Tips For Your Powerpoint Presentation...

Decades back, when computers were being introduced in office premises, PPT was a new terminology that all employees tried to learn. Now PPT has made its way far away from offices and is an integral part of schools, colleges, and several other official proceedings. This is because PPT is an user-friendly computerized method...

Read full article >

Why Should you Become an IT Consultant

Information technology consultancy or Information technology consulting is a specialized field in which one can set their focus on providing advisory services to business firms on finding ways to use innovations in information technology to further their business and meet the objectives of the business. Not only does...

Read full article >

Find Computer Software Classes near you
Computer Software Classes in Bangalore
Computer Software Classes in Delhi
Computer Software Classes in Hyderabad
Computer Software Classes in Chennai
Computer Software Classes in Mumbai
Computer Software Classes in Pune
Computer Software Classes in Kolkata
Computer Software Classes in Jaipur
Computer Software Classes in Ahmedabad
Computer Software Classes in Gurgaon
Online Computer Software Trainer

Looking for Computer Software Classes?

Learn from the Best Tutors on UrbanPro

Are you a Tutor or Training Institute?

Join UrbanPro Today to find students near you
X

Looking for Computer Software Classes?

The best tutors for Computer Software Classes are on UrbanPro

  • Select the best Tutor
  • Book & Attend a Free Demo
  • Pay and start Learning

Learn Computer Software with the Best Tutors

The best Tutors for Computer Software Classes are on UrbanPro

This website uses cookies

We use cookies to improve user experience. Choose what cookies you allow us to use. You can read more about our Cookie Policy in our Privacy Policy

Accept All
Decline All

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 55 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 7.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more

ThinkVidya Learning Pvt Ltd © 2010-2024All Rights Reserved