SELECT
	[GL #]
FROM
	GLDetailTable
GROUP BY
	[GL #]
HAVING
	MAX(ActivityDate) < '20090701';

quote:

---

I am so new at this that I’m still crying where the doctor swatted me on the rear.

---

SELECT
	[GL #]
FROM
	GLDetailTable
GROUP BY
	[GL #]
HAVING
	MAX(ActivityDate) < '20090701';

quote:

---

Can you turn some of this around and then check to see if MAX was zero? MAX(ActivityDate) > '07/01/2009', and MAX < 1

---

-- Test data
CREATE TABLE #tmpGL(GL INT);
CREATE TABLE #tmpActivity(GL INT, ActivityDate DATETIME);

INSERT INTO #tmpGL VALUES (1),(2),(3),(4),(5);
INSERT INTO #tmpActivity VALUES
(1,'20090101'),(1,'20090901'),
(2,'20090102'),
(3,'20090904'),(3,'20091111');


-- this would not retrieve 4 and 5
SELECT
	GL
FROM
	#tmpActivity
GROUP BY
	GL
HAVING
	MAX(ActivityDate) < '20090701';

-- this would retrieve 4 and 5 along with 2
SELECT
	g.GL
FROM
	#tmpGL g
	LEFT JOIN #tmpActivity a ON a.GL = g.GL
GROUP BY
	g.GL
HAVING
	MAX(ActivityDate) < '20090701'
	OR MAX(ActivityDate) IS NULL;

-- so would this.
SELECT DISTINCT
	g.GL
FROM
	#tmpGL g
WHERE
	NOT EXISTS 
	(
		SELECT * FROM #tmpActivity a 
		WHERE a.GL = g.GL AND a.ActivityDate >= '20090701'
	);

-- cleanup	
DROP TABLE #tmpGL;
DROP TABLE #tmpActivity;