AnsweredAssumed Answered

SQL Join Difficulties

Question asked by Gingernut on Nov 19, 2012
Latest reply on Nov 19, 2012 by beverly

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 ?";"|";"";

"M%";

"A%";

"Edu%")

 

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??

 

CAthy

Outcomes