RE:_What_relationship_am_I_missing_in_this_query ?

I think you need to move your second query out of the select statement and into the join section of the query. This chunk of SQL goes and gets the most recent ElementStatusHistoryID by using a GROUP BY and uses it to join in the table at that one row that it finds with the GROUP BY. Hope it

RE: _What_relationship_am_I_missing_in_this_query ?

Thanks for the tips, Chad! Rick -Original Message- From: Chad Gray [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 21, 2008 1:10 PM To: CF-Talk Subject: RE:_What_relationship_am_I_missing_in_this_query ? I think you need to move your second query out of the select statement