join 3 queries

[sarit_s]

Hello
I have 3 queries that i need to join between them but there is a catch 

query number 1 checks for users who sent sms
query number 2 checks if we tried to resend the sms

query number 3 check if we got verification that the sms sent

in the end - i want to see only the cases where we have sent, resend and verify - all of them by id
when im using simple join - i get all the results and not only those with the resend method 

[richgalloway]

It would help to know the specifics of each query.  Without them, the best I can do is

<<query number 1>>
| append [ <<query number 2>> ]
| append [ <<query number 3>> ]
| stats values(*) as * by id