CREATE TABLE RELATIONSHIP
INSERT INTO RELATIONSHIP (CASE,INDIVIDUALID,RELATIONSHIPID) VALUES (1001,1234,4567)
INSERT INTO RELATIONSHIP (CASE,INDIVIDUALID,RELATIONSHIPID) VALUES (1001,1234,4568)
I am trying to build a relationship table. Where i have individual id's and i need to get their relations with another individual , who have same CASENUMBER.
example : I have this data now :
Needed this ( Ignore the relationship, i am just giving example to understand data)
here is the DDL attaached:
Thanks In advance