FileMaker Query Language or FQL

289 topics in this forum

1. New to SQL

   By Ron Neville, August 2, 2016
   • 3 replies
   • 1.4k views
   • 
   • Fitch
   • August 2, 2016

2. Execute SQL across databases

   By rpan, August 2, 2016
   • 2 replies
   • 2k views
   • 
   • rpan
   • August 2, 2016

3. Criteria on other side of join

   By sal88, July 31, 2016   

   • join
   • sql
   • (and 2 more)

      Tagged with:

     • join
     • sql
     • executesql
     • criteria
   • 0 replies
   • 1.6k views
   • 
   • sal88
   • July 31, 2016

4. ExecuteSQL question

   By coolcat, July 9, 2016   

   • executesql
   • 4 replies
   • 2k views
   • 
   • coolcat
   • July 9, 2016

5. Help with executeSQL and Like ?

   By JoVac, June 21, 2016
   • 2 replies
   • 2.4k views
   • 
   • JoVac
   • June 23, 2016

6. Defining Column Width within SQL Select

   By "... you mean these fans?", May 21, 2016
   • 19 replies
   • 12.3k views
   • 
   • comment
   • June 22, 2016

7. Filemaker trades stocks

   By JLanclos, June 14, 2016   

   • filemaker
   • trade
   • (and 3 more)

      Tagged with:

     • filemaker
     • trade
     • stocks
     • api
     • brokerage
   • 0 replies
   • 2k views
   • 
   • JLanclos
   • June 14, 2016

8. ExecuteSQL Novice - condition from a global table

   By gerg nnud, May 31, 2016   

   • executesql global
   • 4 replies
   • 1.3k views
   • 
   • gerg nnud
   • May 31, 2016

9. Passing the SQL LIKE Wildcard Into ExecuteSQL

   By oakbridge, May 25, 2016
   • 1 reply
   • 3.6k views
   • 
   • beverly
   • May 26, 2016

10. Seeking Pointer: New to FM, Oracle/SQL background

    By kisertn, May 12, 2016   

    • scripts
    • sql
    • 4 replies
    • 1.4k views
    • 
    • Fitch
    • May 12, 2016

11. Use SQL to identify duplicate records

    By rekent, May 4, 2016
    • 1 reply
    • 1.1k views
    • 
    • webko
    • May 4, 2016

12. Select Multiple

    By Ron Cates, April 27, 2016
    • 6 replies
    • 1.6k views
    • 
    • Wim Decorte
    • April 29, 2016

13. ExecuteSQL Select Date Filed not working.

    By Devin, April 26, 2016
    • 1 reply
    • 1.3k views
    • 
    • LAIRY
    • April 26, 2016

14. Cross-Tab report with ExecuteSQL

    By David Zakary, April 25, 2016   

    • executesql
    • report
    • 1 reply
    • 2k views
    • 
    • beverly
    • April 26, 2016

15. Troubleshoot SQL Syntax Error

    By adehner, April 25, 2016   

    • executesql
    • 4 replies
    • 2.9k views
    • 
    • LAIRY
    • April 26, 2016

16. HELP - Cannot get working example of SQL Query returning a literal

    By mattp52, April 21, 2016   

    • literal
    • executesql
    • 7 replies
    • 3.4k views
    • 
    • Wim Decorte
    • April 22, 2016

17. ExecuteSQL Hide Duplicates in Portal?

    By R81, April 2, 2016
    • 2 replies
    • 2.5k views
    • 
    • R81
    • April 3, 2016

18. Help with Select Sum

    By hair on fire, March 15, 2016   

    • sql
    • 6 replies
    • 3.5k views
    • 
    • hair on fire
    • April 1, 2016

19. ExecuteSQL use with Virtual Lists

    By Stu412, March 16, 2016   

    • sql
    • virtuallist
    • (and 1 more)

       Tagged with:

      • sql
      • virtuallist
      • parse
    • 2 replies
    • 3.8k views
    • 
    • beverly
    • March 17, 2016

20. ExecuteSQL SUM of Sales Year1 & Year2

    By Mike E, February 11, 2016
    • 4 replies
    • 1.8k views
    • 
    • beverly
    • February 25, 2016

21. SQL novice - where to start?

    By Richmilnix, January 7, 2016   

    • sql
    • 4 replies
    • 2.1k views
    • 
    • beverly
    • January 15, 2016

22. Help ExecuteSQL Newbie

    By John Kostenbader, January 10, 2016
    • 5 replies
    • 1.8k views
    • 
    • Kevin Frank
    • January 10, 2016

23. ExecuteSQL Sum difference between dataviewer and calculation

    By Joost Miltenburg, December 10, 2015
    • 4 replies
    • 1.6k views
    • 
    • Joost Miltenburg
    • December 17, 2015

24. Need a little help with a SQL count calc

    By Rich S, December 7, 2015
    • 13 replies
    • 2.7k views
    • 
    • Wim Decorte
    • December 7, 2015

25. ExecuteSQL - newbie

    By Mr.Voyager, December 5, 2015   

    • executesql
    • 2 replies
    • 1.4k views
    • 
    • Mr.Voyager
    • December 5, 2015

26. Month by Month report

    By sal88, December 2, 2015
    • 7 replies
    • 1.2k views
    • 
    • sal88
    • December 3, 2015

27. ExecuteSQL - Field cannot be found

    By Pat Fellows, December 3, 2015   

    • sql
    • 3 replies
    • 2.3k views
    • 
    • Kris M
    • December 3, 2015

28. ExecuteSQL Strange Bug

    By cgroody, December 1, 2015   

    • executesql
    • 4 replies
    • 1.5k views
    • 
    • Wim Decorte
    • December 2, 2015

29. NOT EXISTS

    By sal88, November 16, 2015
    • 4 replies
    • 2.5k views
    • 
    • sal88
    • November 19, 2015

30. executeSQL refresh, update

    By happymac, November 9, 2015
    • 2 replies
    • 2.3k views
    • 
    • Wim Decorte
    • November 14, 2015

31. SQL to Filemaker 11 advanced

    By sharabi, November 8, 2015
    • 0 replies
    • 873 views
    • 
    • sharabi
    • November 8, 2015

32. SQL on Field Names Containing Spaces

    By Chong-Yee, October 8, 2011   

    • fql
    • sql
    • (and 2 more)

       Tagged with:

      • fql
      • sql
      • field name
      • select
    • 5 replies
    • 28.3k views
    • 
    • PeterWindle
    • October 30, 2015

33. ExecuteSQL() sums and group by ERROR...

    By dwdata, October 22, 2015   

    • sql
    • joins
    • (and 2 more)

       Tagged with:

      • sql
      • joins
      • sum
      • query
    • 3 replies
    • 4k views
    • 
    • dwdata
    • October 23, 2015

34. ExecuteSQL Function to Duplicate records

    By Yilbber Vargas, October 21, 2015
    • 15 replies
    • 2.9k views
    • 
    • Yilbber Vargas
    • October 23, 2015

35. My first ExecSQL Join

    By Ron Cates, October 19, 2015
    • 2 replies
    • 1k views
    • 
    • Fitch
    • October 22, 2015