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 |
|
missMac
Posting Yak Master
124 Posts |
 Posted - 2008-12-16 : 22:00:48
|
| Hello guys,I have two tables, aspnet_users and our original table users.We have been migrating users to a new application and just finished, now, how do i check which values of username "DONT EXIST" in the new table aspnet_users ?thanksMM |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-16 : 22:04:33
|
| You can use like this:Select username from table1exceptselect username from table2 |
 |
|
|
missMac
Posting Yak Master
124 Posts |
Posted - 2008-12-16 : 22:31:54
|
| thanks a lot buddy |
|
|
|
|
|
|
How do i compare two columns [USERNAME] ?