7 Replies Latest reply on May 9, 2016 1:36 PM by beverly

    ExecuteSQL script for filemaker pro 11

    aanshi

      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