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 |
|
archanasql
Starting Member
27 Posts |
 Posted - 2008-01-04 : 14:31:11
|
| Hi,Suppose i have two tables employee and orders.Can i join these two tables with candidate key colums in each table. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-01-04 : 14:43:40
|
| Yes. You don't even have to join on candidate keys. You can join on any column from both tables, but typically they are PKs and FKs.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
|
|
|
Joining two tables without primary key