How do I return a list of unique account numbers?

I have a table that lists all the billing codes assigned to each account.  I want to create a table that will lists the account that don't have a certain code and put those records into a new table.  Since the same account number can be listed multiple times in the table I am querying, how do I get the account to only appear once in the table I want to create?

Thanks.