Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
gcarolino
Starting Member
2 Posts |
 Posted - 2011-12-05 : 14:50:22
|
| Im not sure if its actually comparing so hear is my question.i have 2 tables. A USERS table and an USER_ANSWERS table.USERS_ANSWERuserID Answer Question_no1 yes 13 no 15 yes 11 no 23 yes 25 no 2USERSid user_name1 bill2 jim3 kelly4 allen5 sammy6 patrickI am trying to write a query that will result in a list of the ALL the users with the answers regardless if they answered for a curtian question number. id user_name answer question_no1 bill yes 12 jim null 13 kelly no 14 allen null 15 sammy yes 16 patrick null 1 I have only been able to get a list of users that have answered the question. Any help will be much appreciated. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
gcarolino
Starting Member
2 Posts |
Posted - 2011-12-06 : 08:03:39
|
| Thanks tkizer! |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Comparing 2 Tables