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 |
|
Xander
Starting Member
1 Post |
 Posted - 2007-05-22 : 16:09:05
|
| Hi, I am working on a web app. The app previously had an admin section with a generic aspnet_users table. We have since added a blog (using Presstopia) which created it's own user table. Is there any way to tie these two tables together? I would like to do this instead of going through and changing all kinds of code to combine the tables... so i was wondering how to tie them together to make them essentially the same table without explicitly doing so... thanks. |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2007-05-23 : 05:16:01
|
| make a view which joins the 2 tables together....and make it look like 1 table?issues with delete/inserts/updates however will apply (basicall views only allow inserts/update/delete to 1 table at a time...so this strategy is only useful for read-only views.)you're still (probably) going to have to change code to use the views anyway....try and see if it solves your problems! |
 |
|
|
electriciansnet
Starting Member
2 Posts |
Posted - 2007-05-23 : 09:22:01
|
| Is this also how you populate fields of related tables which are foreign keys such as custeromerID, orderID, customerOrderID ? |
|
|
|
|
|
|
Tieing together...