SQL Error

An error occurred while executing this script.

Here is the information provided by the script:

Error code: SQL Error
Error message: SELECT * FROM products LEFT join category ON prodCategory=catID LEFT JOIN vendor ON vendorID=prodVendor WHERE prodCode='22-G&B's Biscuits' LIMIT 0,1
Script name  
Line number of error:  
 
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's Biscuits' LIMIT 0,1' at line 1