aw... am I not following the rules? WTF man!
Doing it with create scripts and DDL and all the bullshit you want would take way too much time! I'm NOT a SQL Server anything! I'm just trying to get my job done while everybody is gone for the holidays. This thing could be solved just by looking at what I've provided.
If it's such a "redundant design", then why is the solution not working? I'm getting back duplicate records (a.k.a. "redundant records"), and some records w/o teamid in them! Both Table1 AND Table2 have no missing teamid.
If you don't know how to solve this simple JOIN (UNION) the correct way, then just say so!
The "schema" is in my first post. If someone wants to help without bitching about it, then fine!
This is like going to the hospital with COVID-19 and listening to everyone on the staff bitch at you for not getting your vaccine! OR going to the dentist with a toothache and listening to the dentist harping "You don't brush you teeth 3 times a day!" What's done is done! It is what it is. And, in both of these cases, I'M PAYING TO HEAR THIS B.S.... STOP ALREADY!
I suppose you want me to wear a mask too, because you are.
"When coloring, stay in the line, kids... they are our friend, and ONLY do it this way!"
What the hell happened to flexibility and adjusting to what you've been given?
Guess what? You lost.
Someone is asking for more information, and someone is asking YOU to do some work for YOUR problem. We can't work with nothing. You cannot query a picture. This is a free site. With free advice from some very skilled people. You should be saying thank you.
Your tables are garbage. Your data is garbage. If it was so simple, then why can't you figure it out?
And your attitude is worse. Do your own work. We are volunteers who will not put up with your attitude.
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/