Sorry might be a newbie question but I cannot see what generated the error message when
I have two tables joined
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
so far it works fine.
At the table contact the table firma is set as mastertable matched on firmen_id and on contact_id
Ändern Kopie Anzeigen contact contactinfo files FIRMA1
Ändern Kopie Anzeigen contact contactinfo files FIRMA2
As soon as I choose contact know I get the following error message but I cannot see what the error creat
Technische Information
Fehlertyp 256
Fehlerbeschreibung 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 '='2'' at line 1
URL localhost/output_runner/contact_list.php?masterkey=2
Fehlerdatei C:\Program Files\xampp\htdocs\output_runner\include\dbconnection.php
Fehlerzeile 26
SQL Abfrage 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 ='2'
Would appreciate any help <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=3012&image=1&table=forumtopics' class='bbc_emoticon' alt=':(' />
Regards,
GPS
