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

Sreekanth K V Venkat

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

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

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

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

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

Oracle, Hindi, C++, C, MS Office, VBScript,JavaScript,Spoken English etc with 32 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

bcom and diploma incomputer hardware networking

r4 t2 e4
Comments
Dislike Bookmark

View 6 more Answers

Related Questions

Can we make 2 folders of same name in the same place without copying or without changing any script?
First go to the folder or drive where you want to make the same named file or folder. Lets assume that you are creating folder named IT Now create an another new folder and name it as IT and then press Alt+0160 from numeric keypad. That's it!
Sachin
What we do with html?
In HTML we can design web pages with the help of frames, tags, and tables etc.
Suraj
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.
For ADF you should know basics of OAF, SOA, web logic to Start with ADF....then comes the fusion.
Jalil
0 0
6
Hi, I am working as a web designer and want to work as UI developer. So what should I have to learn initially? And learning Angular Js would be a good option?
It is good choice web designer to become web developer (UI developer). Start with the basics first learn HTML and CSS, Then go and continue with bootstrap and Angular js.
Mudita
What are codes required to create a new operating system?
^^ He is asking about Operating System not windows and for creating Operating System you should have a good knowledge of various complex areas of computer science from hardware to software like OS algorithms,...
Vijay

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

Ask a Question

Related Lessons

History of SQL server
In 1988, Microsoft released its first version of SQL Server. It was designed for the OS/2 platform and was developed jointly by Microsoft and Sybase. During the early 1990s, Microsoft began to develop...

Rahul J Rajesh

0 0
0
Efficient Learning Strategies
Type your notes after class Write your notes onto flashcards - Scrabble -Make posters Review flashcards while walking, at gym, etc. Dog-ear pages in the reading where you can find...

Vijith V T

1 0
0
How Motivation Affects Learning and Behavior
Motivation directs behavior toward particular goals. Motivation leads to increased effort and energy. Motivation increases the amount of effort and energy that learners expend in activities directly...

Anshika S.

0 0
0
Essential SQL Tips For Developers And For MS SQL DBA
10 Essential SQL Tips for Developers: SQL is yet another essential language for developers wishing to create data-driven websites. However, many developers are unfamiliar with various aspects of SQL;...

Manoj Kumar Vishwakarma

7 0
0
SQL is not a Rocket Science
I am a Professional and at the inital days I completely hate Databases but I forgot to know that "Everything starts and ends with us".It means the INTEREST starts with us. Everybody knows this but none...

Annamalai M

0 0
0

Recommended Articles

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 >

Top 5 Skills Every Software Developer Must have

Software Development has been one of the most popular career trends since years. The reason behind this is the fact that software are being used almost everywhere today.  In all of our lives, from the morning’s alarm clock to the coffee maker, car, mobile phone, computer, ATM and in almost everything we use in our daily...

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 >

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 >

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

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