How dirty are the tables in your environment?

N2IT

I was just wondering if you all have to go through what I have to. The other day I wanted to join some tables essentially joining login id with some attribute data then capping off the select with state and city. Well well well when I go to run the join I get back multiple records because there are other address linked to the key. Soooooooooo I tried to write a subquery to aggregate those with a min function and it didn't work. I look at my co workers query and she had to write a multiple subqueries and a union all to account for addresses that were blank. UGH Is this normal WOW this is painful sometimes. Not to mention a temp table.

RobertKaucher

I'm curious, what does the data model look like?

N2IT

The ERD of the database / tables?