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 [email protected], "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.
>
