PL/SQL (MOSC)

MOSC Banner

query with 3 tables

in PL/SQL (MOSC) 5 commentsAnswered ✓

I have 3 tables: on the first, I have the names of the people, on the second, the names of the courses, and on the third, the courses that people are taking.


tab_first

-------------------

id name

1st

2b


tab_second

--------------------

id description

1 course x

2 course y


tab_third

---------------------

id_people id_course

   1 1

   2 1

   2 2


I would like a query that produces the following result:


Person Course X Course Y

------------------------------------------------

    to X

    b X X


Is this possible?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center