| Subject | Select records with duplicate fields | 
|---|---|
| Author | markd_mms | 
| Post date | 2006-05-19T01:13:06Z | 
This is probably a real easy question but I've never had to do it
before and for the life of me I can't figure it out.
I have a table that lists actor id's and title id's for a video
database and I just need to list actor id's where there are duplicate
title id's.
e.g.
actor_id title_id
1 1
2 1
3 2
and the result would be
actor_id
1
2
Any help is appreciated.
TIA
            before and for the life of me I can't figure it out.
I have a table that lists actor id's and title id's for a video
database and I just need to list actor id's where there are duplicate
title id's.
e.g.
actor_id title_id
1 1
2 1
3 2
and the result would be
actor_id
1
2
Any help is appreciated.
TIA