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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-09-25 : 07:29:36
|
| troy writes "hello to all,how can i generate a script using t-sql or stored procedure where in i can retrieve recordsets not included in a conditional two tables join together? normally, it is very easy to retrieve records in joining two tables using the primary key in one table and foreign key in another table. but, what about those records not included in the conditional joins?thank you." |
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
Posted - 2006-09-25 : 07:37:19
|
| How about using Left join or Right join?Post some sample data if you want an extact answer??Chirag |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
retrieving records not included in joins