title: sqlite join virtual table
body: <p>I am woking on sqlite, I am not able to join two virtual tables. I am using Following query to join the table, but it is returing empty records.</p>
  
  <p>select provFName from xp_messages_recepient  LEFT JOIN all_provider  on recepientUserId=providerID WHERE xpMessageId='1' </p>
  
  <p>Let me know,</p>
  
  <p>1: Is this allowed?
  2: If it is allowed, what wrong I am doing there?</p>