SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Three ways join with composite primary & foreign keys

Eslam_ElbyalyDec 14 2013 — edited Dec 17 2013

hi all ,

i have three tables

1- test_data_items (test_data_item_id pk

, test_data_item_name)

2- data_items_in_tests (test_id , test_data_item_id) -- the two are composite primary key .

3- test_results ( test_results_id pk ,

test_admin_id ,

test_id , test_data_item_id ) -- the two are composite foreign key .

how to join the three tables ?

i want all the data , but i do not know how to write the join conditions when there are composite primary and foreign keys ?

thanks a lot

This post has been answered by Frank Kulash on Dec 14 2013

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 14 2014

Added on Dec 14 2013

8 comments

3,218 views