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 |
|
sqlclarify
Yak Posting Veteran
56 Posts |
 Posted - 2009-01-27 : 00:22:26
|
| Hello,I have a group of tables which I have joined and I am going to use it to get a couple of columns from this joined table (lets call it A). But I would like to join this "joined table" to another "joined table" (kind of like a subquery). But how would I determine the key of this joined table A. It involves recursive relationships and lots of tables that have been joined together.Can anyone help me out please.. |
|
|
bklr
Master Smack Fu Yak Hacker
1693 Posts |
Posted - 2009-01-27 : 00:35:14
|
| do u have any common columns in the subqueries r once post ur subqueries |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-27 : 08:41:07
|
| no way we could suggest you anything from info given. give some sample data from your tables with column structure and then we will be able to provide you more help |
|
|
|
|
|
|
key of a view?