RIGHT JOIN (or RIGHT OUTER JOIN): It’s the opposite of a LEFT JOIN. It keeps all rows from the right table and matches from the left. Less common than LEFT JOIN, but good to know it exists.

edit: I didn't read the whole question. :facepalm: But basically, grouping by the day of week in place of date should get you where you want to go. Start with the query you posted above, then use that ...

In the original proposal for the World Wide Web, Tim Berners-Lee wrote: A generic tool could perhaps be made to allow any database which uses a commercial DBMS to be displayed as a hypertext view. We ...

How to combine values from a column into a single cell using Microsoft Excel’s Power Query Your email has been sent The article How to concatenate values in a single Excel column to a single row shows ...

We are halfway though many of our applications switching from Access to SQL Server (my idea to deal with the fact many of our applications are locking each other out / thrashing every 8-10 min ...