title: how to select data when i use from fulltext and inner join?
body: <p>I have two tables and  i want select data two tables with inner join that it work true. but my problem is in out of query</p>
  
  <pre><code>SELECT 
    TBL_USERSMETA.NAME,
    TBL_USERSMETA.FAMILY,
    TBL_USERS.* 
    FROM TBL_USERSMETA 
    INNER JOIN
      TBL_USERS 
        ON TBL_USERSMETA.ID 
        AND TBL_USERS.ID In (
          SELECT ID 
          FROM TBL_USERS 
          WHERE MATCH(USERNAME) AGAINST('a*' IN BOOLEAN MODE))
  </code></pre>
  
  <p>problem :
  <img src="https://i.stack.imgur.com/S4KSd.png" alt="enter image description here"></p>