Thank you, but what is j1 and j2 ? _____
From: [email protected] [mailto:[email protected]] On Behalf Of Kevin McCoy Sent: Monday, June 29, 2009 5:27 PM To: [email protected] Subject: [delphi-en] Re: Is this possible? if so how This probably isn't optimal, but here is a SQL query that works in MySQL and does what you want. ------------------------ SELECT name, (select state from junk j1 where j2.name=j1.name order by state limit 1) as state FROM junk j2 where state in ('CA', 'FL') group by name ------------------------ Junk is a 3 column table: ID : integer - unique id Name:string state:string I added the ID column just to make it easy to edit for me. I am not an Access programmer, so I have no idea if you can do such a query in that DB. --- In delphi...@yahoogrou <mailto:delphi-en%40yahoogroups.com> ps.com, "Perry Kappetein" <pkappet...@...> wrote: > > yes, your right. > messed up my example > > it's in a access table, that gets loaded into VirtualTree (Soft-gems.net) > > I was trying to do it within virtualTree, but it's getting me nowhere. > [Non-text portions of this message have been removed]
