y easier way to do this.
> Thanks
> -- Jeff
>
> From: S. Isaac Dealey <[EMAIL PROTECTED]>
> Sent: Friday, May 20, 2005 9:16 AM
> To: CF-Talk
> Subject: Re: OT: SQL Query Question
> select t.* from test t where t.actid in
&g
I knew there was any easier way to do this.
Thanks
-- Jeff
From: S. Isaac Dealey <[EMAIL PROTECTED]>
Sent: Friday, May 20, 2005 9:16 AM
To: CF-Talk
Subject: Re: OT: SQL Query Question
select t.* from test t where t.actid in
(SELECT MAX(t2.actID
Jeff Chastain wrote:
>
> I have a table that looks something like this
>
> crIDactIDdescriptionowner
> 1 1Test 444
> 1 2Test Update124
> 2 1Test 578
>
> Now, what I need is a listing of all d
select t.* from test t where t.actid in
(SELECT MAX(t2.actID) FROM test t2 where t2.crID = t.crID)
ought to work...
s. isaac dealey 954.522.6080
new epoch : isn't it time for a change?
add features without fixtures with
the onTap open source framework
http://www.fusiontap.com
http://coldfusio
Sorry for the off-topic, but I have been beating on this one for a while and
the only answer I can find is really, really ugly. So, hopefully somebody
knows more about queries that I do and can show me the error of my ways
I have a table that looks something like this
crIDact
5 matches
Mail list logo