Skip to Content
0
Sep 12, 2007 at 01:23 PM

Compare users in the table

43 Views

Hi Gurus,

I want to compare two users (UNAME) in the table AGR_USERS by roles (AGR_NAME). Let's say User1 has roles A, B, C, D and User2 has role A, F, G. I want the output shows the discrepancy of the roles between users as such

User1 User2

F B

G C

D

Any help would be greatly appreciated.