Hi everyone,

maybe I don't see the woods for the trees, but does anyone have an idea what is wrong with the following SQL?? <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=3013&image=1&table=forumtopics' class='bbc_emoticon' alt=':(' />

Many thanks for any kind of hint.

gps
SELECT contact.contact_id, firmen_id, titel, anrede, vorname, name, tel, concat_ws( ' ', anrede, ' ', titel, ' ', vorname, ' ', name ) AS person, concat_ws( ' ', firma1, ' ', firma2 ) AS firma

FROM contact

INNER JOIN firma ON contact.company_id = firma.firmen_id

WHERE = '1'

LIMIT 0 , 30
MySQL meldet:

1064 - 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 '= '1'

LIMIT 0 , 30' at line 4