A table in my database has following fields:
ClientID, MatterID, TitleNo all three fields are compound key. Some time the same MatterID can have more than one TitleNo in which case they need to be displayed in a row on a report rather than as a two different records.
I am trying to work it out as self join but unable to get my head around it. For quick reference/understanding I am attaching the file there are three records in the table first two records have same ClientID, MatterID and two different TitleNos. as two records. Whereas the third record has same ClientID, MatterID and two different TitleNos, however, two different TitleNos have been recorded in single row. This was done intentionally for understanding purpose that what is required to achieve.. Any help suggestions highly appreciated.
ClientID, MatterID, TitleNo all three fields are compound key. Some time the same MatterID can have more than one TitleNo in which case they need to be displayed in a row on a report rather than as a two different records.
I am trying to work it out as self join but unable to get my head around it. For quick reference/understanding I am attaching the file there are three records in the table first two records have same ClientID, MatterID and two different TitleNos. as two records. Whereas the third record has same ClientID, MatterID and two different TitleNos, however, two different TitleNos have been recorded in single row. This was done intentionally for understanding purpose that what is required to achieve.. Any help suggestions highly appreciated.