Getting only one row of data per Primary Key when there are many Foreign Keys that equals it
I have a procedure where I am trying to fetch the only on row of data per Foreign Key (FK) per (PR) in a table (turing one-to-many relationships to a one-to-one table).
I have some tables that looks like below. (NOTE: My tables do not actually look like this, these are just examples.)
Getting only one row of data per Primary Key when there are many Foreign Keys that equals it
I have a procedure where I am trying to fetch the only on row of data per Foreign Key (FK) per (PR) in a table (turing one-to-many relationships to a one-to-one table).
I have some tables that looks like below. (NOTE: My tables do not actually look like this, these are just examples.)