AnsweredAssumed Answered

ExecuteSQL script for filemaker pro 11

Question asked by aanshi on May 5, 2016
Latest reply on May 9, 2016 by beverly

I am using  Filemaker Pro 11. There is 2 tables "Asset" and "Model".

 

AssetIdModelMake
1000AApple
1001ASamsung

 

Model IdModel
Make
M101AApple
M102AMotorola

 

I want to find model Id for model A and Apple and then want to export this records as csv

 

Final output

 

AssetId
Model Id
Model
Make
1000M101AApple

 

How to achieve this with the help of Execute SQL script in FileMaker Pro 11 ?

 

Thanks in advance

Outcomes