PHP / MySQL - Confusing Query

[RetLiesee]

Im trying to construct a query that goes over 3 tables and im COMPLETELY stumped ... my knowledge limit is basic 1 table query and i need some help before i stick my head in a blender.I have the following query\[code\]SELECT * FROM internalrole WHERE introle = $imarole\[/code\]Im fine with that part .. its the next thats getting me all stressed.That query returns the following columns ( id, user_id, introle, proven, used )What i then need to do is take the user_id from the results returned and use it to get the following\[code\]SELECT * FROM users WHERE id = user_id(from previous query) AND archive = 0 and status = 8\[/code\]I need to put that into 1 query, but wait, theres more .... from the results there, i need to check if that user's 'id' is in the availability table, if it is, check the date ( column name is date ) and if it matches todays date, dont return that one user.I need to put all that in one query :S ... i have NO IDEA how to do it, thinking about it makes my head shake ... If someone could help me out, i would be eternaly grateful.Cheers,