join(r,s,p)

r(A int, B char(10))
1,'a'
2,'a'
2,'c'
3,'b'


s(B char(10), C int)
'a',2
'a',4
'b',5
'd',3

p(C int, D char(15))
2,'e'
2,'f'
5,'g'