Recent content by bigteks

Perfect! Thanks, that did it.

Data for the Issues table: Data for the Status table: Expected output from the query: Let me know if you need more than that or if it is not clear. Thanks

I get the same result without any errors by eliminating the GROUP BY statement entirely. I would like to understand what that does to include it and what happens by excluding it. Currently it is not reducing to one row per Issue. Here is the latest query that almost works but produces a join...

OK it is almost working. It was saying "You tried to execute a query that does not include the specified expression 'Expr2' as part of an aggregate function. So I fixed this by adding all the fields in the query to the GROUP BY statement, like this (I also eleminated the expr & table...

I am making a very simple activity tracking app. There are 2 main tables, Issues & Status. There are many Status updates for each Issue. There are lookup tables for the Environment, Project, State and Worker fields but I'm not concerned about that part right now. Issues Table: IssuesID...