QuerySmith 4.6.8 is now available. This release allows for user defined order of tables in the From clause of a query.

You can download the latest version on the download page.

QuerySmith 4.6.7 is now available. This release features a minor bug update for users using a MySQL server on a Linux, Mac or UNIX operating system. The default behavior of MySQL on UNIX is to use case-sensitive aliases in queries. One of the dictionary lookup queries in QuerySmith was using both uppercase and lowercase alias references. This update does not affect users running MySQL servers on Windows.

You can download the latest version on the download page.

QuerySmith 4.6.6 is now available. This release features a change to the Installer, we’ve eliminated the requirement to reboot during the installation of the prerequisite Office support files. Also, we’ve enhanced the appearance of the Office 2010 themes (blue, black, and silver).

You can download the latest version on the download page.

QuerySmith 4.6.5 is now available. The list of changes includes:

• need to escape quote characters in filter values (including in lists)
• issue grouping on columns not selected in the query
• drag and drop filter into or out of subqueries failing
• remove query manager, use file chooser instead
• wildcard search in database object list causes focus loss, subsequent character loss
• should be able to open existing query from current query window
• pivot changes should mark query as dirty
• tab order in connection editor has cancel before ok
• rename layout to arrange
• add subquery alias to property grid
• SELECT subquery not showing up in FROM subquery
• remove where exists and having exists subqueries, move to easier where and having subqueries
• simplify field names in pivot grid

You can download the latest version on the download page.

We’ve been listening to client requests for more help in getting started with QuerySmith, and in querying databases in general. With thanks to the folks over at TheMovieDB, we’ve created a sample Movies database (using Access) that you can use to get started with QuerySmith. We’ve got around 10,000 movies, 85,000 actors and support staff, movie studios, filming locations and more to help you learn how to query.

We’ve got a starter list of a dozen queries or so ranging in complexity that we’ll be building over time in order to illustrate how to perform certain tasks like joins, subtotals etc. We can also use this data to show off advanced concepts like cross-row calculations and things that are ordinarily a little harder in SQL.

We’ve randomized some of the data in the database to fill in gaps that were there, and keep in mind that’s it’s just a sample so it might be missing your favorite movies or favorite actors.

You can download the latest version on the download page.