Select,From,Join,Where within 1 query MySQL Wondering if its possible to use WHERE within such a big query string?
I cannot seem to achieve what I want once I add Where into the query.

customer         
+----+------+------+
| id | type | name |
+----+------+------+
| 1  | boy  | dave |
| 2  | girl | lisa |
+------------------+

order
+----+--------+
| id | status |
+----+--------+
| 1  |  done  |
| 2  |  done  |
+-------------+

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


I assumed this would return result

'id' = 1
'type' = boy
'name' = dave
'status' = done


But instead I get errors.

If I do not include Where, I will get result

'id' = 1
'type' = boy
'name' = dave
'status' = done

'id' = 2
'type' = girl
'name' = lisa
'status' = done


Thanks for any help in advance.
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'