Two Stored procedures to linked for the output
===

I have two procedures p1 and p2. My p1 gives me 4 columns output. I want a single column from p1 to be used in p2 procedure in a select query output in where condition. I am using mysql, 
Please suggest it.