Help with joining mysql statments

[mike12255]

I got two statments:

 

"SELECT id FROM approvednotes WHERE authoer = '$username'";

"SELECT nid FROM usersdownloaded WHERE username - '$author'";

 

and then once I get results from both of those I want to search approved notes again using only the matches from the statements above and what I want to select this time is "SELECT * FROM approvednotes WHERE md5 ='$md5'"; But I dont actually want to search all the listings just the ones that returned true in the first two statements, is there a way to join these three statements into one? I hope I made myself clear if not let me know and ill try to reexplain.

 

[spec36]

Look up LEFT JOIN in the mysql manual that corresponds to your mysql version. I think that will explain what you are trying to do.

[mike12255]

Thanks for pointing me in the right direction, will go look it up now.