Code: Select all
SELECT p.first, p.name, c.category, p.sub, p.phone, p.cell, p.email
FROM pdata p
JOIN cdata c
ON p.Catid=c.Catid
WHERE p.Catid=2
ORDER BY p.sub, p.first, p.name;
SQL Status: HY000
Error code: 1000
Syntax error in SQL statement =>
syntax error, unexpected $end, expecting BETWEEN or IN or SQL_TOKEN_LIKE
I don't have a clue as to what is wrong. Please help.
R