title: how to fix Error Code: 1054. Unknown column in my sql
body: <p>i write below code and i have Error Code: 1054. Unknown column 'referenceinfo.mid' in 'on clause'<br>
      <code>create table newenron as 
      SELECT employeelist.eid
      ,employeelist.firstName
      ,employeelist.lastName
      ,employeelist.Email_id
      ,employeelist.status
      ,message.mid
      ,message.sender
      ,message.subject
      ,message.body
      ,message.folder
      ,recipientinfo.rid
      ,recipientinfo.mid
      ,recipientinfo.rvalue
      ,referenceinfo.rfid
      ,referenceinfo.mid
      ,referenceinfo.reference
      FROM employeelist
      INNER JOIN message ON employeelist.Email_id = message.sender
      INNER JOIN recipientinfo ON message.mid = referenceinfo.mid
      INNER JOIN referenceinfo ON recipientinfo.rid = referenceinfo.rfid</code>                 how can i fix it?
  thank for your taking time.</p>