I am running Filemaker12 on WIndows & and exploring SQL SQLBuilder Most of the time things work as expected but I cannot seem to get this to work
Tables are Customer and Machine
Joined on Acc No or _Acc No in both tables
I want to show all the Machines beginning with M that are Active (begin with A) and I want to show the Business Type from the Customer Table
As soon as I add the Business Type to the WHERE the SQL breaks
The Join is working as before I add the above line I can see the Business Type
// Name: Machines Installed
// Date: 11/19/2012
ExecuteSQL ("SELECT Machine.ActiveDead , Machine.Model , Customer."Business Type"
FROM Machine Machine
INNER JOIN Customer Customer ON Machine."_AccNo"=Customer.AccNo
WHERE Model LIKE ? AND ActiveDead LIKE ? AND "Business Type" LIKE ?";"|";"";
Any ideas much appreciated as I am loving this SQL stuff when it works
Also why is it showing from Machine Machine ie naming the table twice??