MySQL Server Behaviors. MySQL Error 1064. Error in SQL syntax. Refer to manual. I am using MySQL 5.6.17, PHP 5.5.12, Apache 2.4.9. DW ver. 6
Building a query for local server.
Partial code:
SELECT table+2.*, table+2_2.*
FROM table+2, table+2 AS table+2_2
WHERE table+2.VendorName LIKE WAQB_Param1 OR table+2.MWDVBE LIKE WAQB_Param2 OR table+2.SmallBusiness LIKE WAQB_Param3 OR table+2.CMASContractNo LIKE WAQB_Param4 OR table+2.BaseContractNo LIKE WAQB_Param5
Error 1064 reads
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 'table+2_2.* FROM table+2, table+2 AS table+2_2 WHERE table+2.VendorNa' at line 1
Obviously I was hoping to avoid having to learn MySQL syntax through the use of your program.
Thanks