I'm sure this is a very easy question to resolve but here goes
I have a table with a few fields one of them is user_id, in my users table i have fname, lname, telnum, and some other fields including a corresponding user_id.
How do i setup an event to send an email when a record is added into say trouble_tickets table, that will pull the fname and lname out of users table for matching user_id?