Category Archives: Queries

Watch Out ~ Query Behaviour of Control Break keys

At some stage in the last ten years, the behavior of what the Control Break keys did to queries changed. Before the Ctrl-Break key sequence used to stop the query when it had finished its action. Now the way it … Continue reading

Posted in Queries | Leave a comment

Tricky Queries

One of the issues that you have may have to solve is to provide a report with the totals in columns not in rows. In other words, provide a report just like your boss used to do it when the … Continue reading

Posted in Queries | Leave a comment

Tame the Crosstab Missing Column Beast

Crosstab queries are a powerful means of summarizing data. But they can sometimes lead to unexpected situations. Mike Watson looks at how you can ensure that your data-driven crosstab reports can work reliably. Along the way, he also shows how … Continue reading

Posted in Queries | Leave a comment

Subquery Notes

Following up on a series of articles that have been featured over the past few months, Peter Vogel takes a look at a variety of issues around subqueries — including those occasions when you shouldn’t use a Join. Over the … Continue reading

Posted in Queries | Leave a comment

SQL Without Joins

If you always join tables you put in a query, then you aren’t taking advantage of one of the fundamental features of SQL. Not only that, Peter writes, but you’re also missing an opportunity to see how SQL really works. … Continue reading

Posted in Queries | Leave a comment