I am a novice when it come to queries such as this and was hoping someone could help me
write a query that tells me how many records have the same ID and vendor number.
|ID | vendor_no | date |
|2354 | 578 | "2005-12-23"|
|2355 | 334 | "2005-12-24"|
|2356 | 339 | "2005-12-26"|
|2357 | 339 | "2005-12-26"|
|2358 | 339 | "2005-12-26"|
|2359 | 445 | "2005-12-26"|
|2354 | 522 | "2005-12-27"|
|2355 | 522 | "2005-12-27"|
Would I use select count? Any help would be greatly appreciated.
A people that values its privileges above its principles soon loses both.
-Dwight D. Eisenhower.
