I's so sorry. You are very correct. The sample data is bad.  ID should be 
unique. Here it is corrected.

 |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"|
 |2360  | 522              | "2005-12-27"|
 |2361  | 522              | "2005-12-27"|
 
 
[EMAIL PROTECTED] wrote: > 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.

I'd need a clearer spec to offer advise.  What results would you want
from the example data?  2354 is there twice but with different vendor
numbers.  And 522 is there twice with different IDs.  One interpretation
of "[records with] the same ID and vendor number" is 0 because no record
has both the same as any other.





A people that values its privileges above its principles soon loses both.
 -Dwight D. Eisenhower.

Reply via email to