Grouping data by ID

[Freida]

I have a table that has tax id's that may or may not have multiple vendors.
I want to write a query that only shows the ID's with multiple vendors
associated with it, only if they have different address.

For example if there are 3 vendors that have the same address, I do not want
those records to show up in my query. now if the Tax id has 3 vendors
associated with it, at 2 different address I want to see all 3 vendors.

Doesn't seem that hard but I just got back from maternity leave and cannot
remember how to do anything.

 

[Dorian]

Is the address all in just one column and can you guarantee that there will
be consistent formatting? e.g. one record does not contain St. and another
Street or one contain Apt 5 and another contain Apt # 5?
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".

 

[Freida]

There is an address 1 and address 2, city, state and zip columns. Address 2
is used for the suite/apt #. And I cannot guarantee the consistency, but if
the same address shows up twice b/c of "st" or "street", that's okay b/c
there won't be a whole lot of data so I will be able to eyeball it.