Bit of SQL help

[cotton31]

Hi all,

How would I go about finding all the entries in my table that have the same value in a field as another entry?

To be more clear, I need to find all staff who have the same home branch as a specified staff member...

Let me know if it doesn't make sense

Cheers,

 

[cotton31]

Cheers mate, that worked a treat (first one)!

Now how do I show only those entries where a value appears more than once in that table - I need to show only those members who have a membership at more than one branch - so I thought I could do it by only displaying the entries where the branchid appears more than once?

Sorry for the questions!