Going Further
SQLexplorer.GoingFurther History
Hide minor edits - Show changes to output
Changed lines 5-6 from:
Check out Jason's video of this here: %newwin% [[http://www.youtube.com/watch?v=RpOqaGPGgvk | Going Further (aggregates)]]
to:
Check out Jason's video of this here: %newwin% [[http://www.youtube.com/watch?v=RpOqaGPGgvk | Going Further]]
Added lines 5-6:
Check out Jason's video of this here: %newwin% [[http://www.youtube.com/watch?v=RpOqaGPGgvk | Going Further (aggregates)]]
Changed line 9 from:
By editing this directly you can start playing with syntax that isn't in our UI, things like %newwin% [[http://www.w3schools.com/sql/sql_func_sum.asp | SUM]] and %newwin% [[http://www.w3schools.com/sql/sql_groupby.asp | GroupBy]].
to:
By editing this directly you can start playing with syntax that isn't in our UI, things like %newwin% [[http://www.w3schools.com/sql/sql_func_sum.asp | SUM]] and %newwin% [[http://www.w3schools.com/sql/sql_groupby.asp | GroupBy]].
Added lines 6-7:
By editing this directly you can start playing with syntax that isn't in our UI, things like %newwin% [[http://www.w3schools.com/sql/sql_func_sum.asp | SUM]] and %newwin% [[http://www.w3schools.com/sql/sql_groupby.asp | GroupBy]].
Added lines 1-5:
!! Tips for getting the most out of SQLexplorer
Definitely take the time to add your own table occurrences to the explorer rather than just playing around with our test tables. Since you can copy the query as a FileMaker calculation, you won't have to worry about escaping quotes or misspelling field names.
After a while you'll find it faster to edit your queries right on the review tab after you've build up the basic syntax. So don't by shy... you can always click "restore query" to rebuild the working query you started with in the step-by-step wizard.
Definitely take the time to add your own table occurrences to the explorer rather than just playing around with our test tables. Since you can copy the query as a FileMaker calculation, you won't have to worry about escaping quotes or misspelling field names.
After a while you'll find it faster to edit your queries right on the review tab after you've build up the basic syntax. So don't by shy... you can always click "restore query" to rebuild the working query you started with in the step-by-step wizard.
