title: MySQL Query with Multiple Tables
body: <pre><code>Table: UserInfoTbl
  =======================
  | username  | type    |
  =======================
  | user0001  | premium |
  | user0002  | premium |
  | user0003  | normal  |
  | user0004  | premium |
  =======================
  
  Table: UserPvTbl
  ========================
  | username | fUsername |
  ========================
  | user0003 | user0002  |
  | user0002 | user0001  |
  | user0003 | user0001  |
  ========================
  </code></pre>
  
  <p>How can I select all the information from UserInfoTbl where fUsername of UserPvTbl has username of user0003?</p>
  
  <p>Edit: Meaning that I need to retrieve information of user0002 and user0001 from the UserInfoTbl</p>
  
  <p>Edit2: Relationship between both tables : UserInfoTbl.username = UserPvTbl.username</p>