Duplicates

[Thomas]

I am working with PO #'s and Account #'s. Some PO #'s are
duplicated with diffrent acct #'s. Some PO #'s are not
duplicated and are matched up to a single account # I am
trying to pull the Duplicated PO #'s with diffrent account
numbers only. Can you help?
Example:
PO# Acct#
00891 8498993
00896 8498994
00897 16621
00897 8436215
00902 303502

When I run the query I want it to show:
00897 16621
00897 8436215

 

[Chris]

SQL would look like this:


Select[PO#],[Account#] from Table where [P0#] in (Select
[p0#] from Table Having Count([Account#]) > 1)


Chris