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 crID

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

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 distinct

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 cf-talk@houseoffusion.com Subject: Re: OT: SQL Query Question select t.* from test t where t.actid

Re: OT: SQL Query Question

2005-05-20 Thread S . Isaac Dealey
this. Thanks -- Jeff From: S. Isaac Dealey [EMAIL PROTECTED] Sent: Friday, May 20, 2005 9:16 AM To: CF-Talk cf-talk@houseoffusion.com Subject: Re: OT: SQL Query Question select t.* from test t where t.actid in (SELECT MAX(t2.actID) FROM test t2