simple MYSQL Stored Procedure

Job ID: 31595892

Budget: $10 – $30 USD

I want some one to type a simple SP that checked two tables.
first query check if user who call SP exist
if yes, then check the other value in 2nd table if exist and return value.