Re: OT: SQL Query Question

2005-05-20 Thread S . Isaac Dealey
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

Re: OT: SQL Query Question

2005-05-20 Thread Jeff Chastain
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

Re: OT: SQL Query Question

2005-05-20 Thread Jochem van Dieten
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

Re: OT: SQL Query Question

2005-05-20 Thread S . Isaac Dealey
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

OT: SQL Query Question

2005-05-20 Thread Jeff Chastain
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