MYSQL Inner join results is empty
<p>I need to join 2 tables based on a customer ID.</p>

<p>My tables are Table1 = 'vbq-customers' and Table2 = 'vbq-sales'</p>

<p>The columns of Table1 are : Customer_id | First_name | last_name etc..
The columns of Table2 are : Receipt_nb | receipt_date | receipt_customer_code etc..</p>

<p>I want to join on Customer_id = receipt_customer_code</p>

<p>The result of this query is empty despite the fact that if have checked the presence of similar info to be joined.</p>

<pre><code>BEGIN

DROP TABLE `vbq-sales-customers`;
CREATE TABLE `vbq-sales-customers`
AS

(SELECT * 
  FROM `vbq-sales` 
  INNER JOIN  `vbq-customers`
  ON `vbq-sales`.receipt_customer_code=`vbq-customers`.Customer_id

);

END`
</code></pre>

<p>Can anyone help me figure out what I am missing here?</p>