hi can this be use all together?
here is my query:
SELECT CONCAT(fullname," ",address1," ",city," ",state," ",zip," ",firstname," ",lastname," ",email," ",hearaboutus," ",homephone," ",workphone," ",cellphone) AS searchterm
FROM referrals
INNER JOIN address ON address.clientid=referrals.clientid
WHERE referrals.firstname is not null AND address.prim=1
HAVING searchterm LIKE '%{$term}%'
On the console im getting the error "[Err] 1054 - Unknown column 'address1' in 'field list'"...
MySQL CONCAT, HAVING and JOIN
from Databases http://ift.tt/29w5bUg
via IFTTT
MySQL CONCAT, HAVING and JOIN
Databases
Out Of Topic Show Konversi KodeHide Konversi Kode Show EmoticonHide Emoticon