Best way to do this query

M

Mick

I'm a bit new to Access and i want to do an SQL query

Basically i want to query a single table column and i want to find all
values in the columns that are the same.

At the moment i am atempting a join, however is there an easier way to
do this?
 
M

MGFoster

Mick said:
I'm a bit new to Access and i want to do an SQL query

Basically i want to query a single table column and i want to find all
values in the columns that are the same.

At the moment i am atempting a join, however is there an easier way to
do this?
Click to expand...

SELECT column_name
FROM table_name
GROUP BY column_name
HAVING Count(*) > 1
 
M

Mick

I thought so, that was the way i had it first, i just wondered if doing
a join or somthing was the better way of doing it

Thanks MGFoster
 
Top