Nynaevelan
Joined: 25 Jun 2009
Posts: 67
|
 Posted: Thu Nov 12, 2009 1:18 pm Post subject: Access Database - SQL Help |
 |
|
Hi Guys:
I need some SQL help with my movie database. I am trying to find a way to identify and remove records with duplicate genre's. I have the SQL statement that identifies the records with duplicates but I need a way for the SQL to identify the records without it showing the first record, in other words the records with the smallest GenreID. If you look at the statement can you see if it is possible to accomplish what I need? TIA
| Code: | | In (SELECT [MovieID] FROM [GenresLink] As Tmp GROUP BY [MovieID] HAVING Count(*)>1 ) |
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
