Best way to do this query

  • Thread starter Thread starter Mick
  • Start date Start date
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?
 
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
 
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
 
Back
Top