|
-
Dec 9th, 2012, 05:39 PM
#1
Thread Starter
PowerPoster
get unique records with counts of duplicates?
so I have 2 tables which join together.
I want to know how many records on TrackAudit, between 2 dates, exist and the number of times they exist. how would I do this?
Table Tracks: ID, TrackName, TrackFileName, ArtistID, GenreID
Table Audit: ID, TrackID, DateOfEntry
So Track Audit will have multiple entries for a track but I want a list of each track, within a time period, showing the # of occurances for that track.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|