Select,From,Join,Where within 1 query MySQL
from the error you've described, I am pretty sure it´s a mere missing single quotes around the word "boy" in your query. That's why removing the where clause it works.

SELECT `customer`.*,order.status 
FROM `customer` 
JOIN `order` on customer.id = order.id 
WHERE customer.type = 'boy'