hello,

I have a single table with a design something like this

name value
item1 123
item2 456
item3 234
item1 245
item4 278
item2 763
item1 741

what i need to do is select all 'name' where there is multiple entrys eg return
item1 123
item1 245
item1 741
item2 456
item2 763

any sugestions would be appreciated


Chris

select * from TABLE
where name not in
(select name,count(*)
from TABLE
group by name
having count(*) = 1)
order by name

Hello,
The above query gives the following error message:
You've written a subquery that can return more than one fiel without using the EXISTS reserved word in the main query's FROM clause. Revise the SELECT statement of the subquery to request only one field.


I have used
select name,count(*)
from TABLE1
group by name
having count(*) > 1
to return what 'names' are entered more than one but i would like to be able to see the 'value' for each 'name' without having to use it in another query.

By the way im useing a Access DB


Chris