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 |
|
sqllearner
Aged Yak Warrior
639 Posts |
 Posted - 2005-08-12 : 12:05:44
|
| Please somebody help me with the answers:-1.How do you find the difference between two tables?2.What is the physical representation for a many-to-many relationship? 3.How do you find the difference between two tables? |
|
|
sqllearner
Aged Yak Warrior
639 Posts |
Posted - 2005-08-12 : 13:03:59
|
| Sorry the 3rd question was3. How do you limit the return set produced by a join? |
 |
|
|
sqllearner
Aged Yak Warrior
639 Posts |
Posted - 2005-08-12 : 13:21:35
|
| Is this answer correct for question 3...Please somebody help me with thisIf you are interested in only the rows for which the restriction is true, place the restriction in the where clause. However, if you want to include all the rows of the outer table, regardless of whether they satisfy the restriction, place the restriction in the on clause. |
|
|
|
sqllearner
Aged Yak Warrior
639 Posts |
Posted - 2005-08-12 : 14:21:43
|
| Please correct me if the answer for question1 is wrong SELECT table1.Key_id, table1.col2,table1.col3 FROM table1 LEFT JOIN ( SELECT key_id FROM table2 (where clause if needed) ) DiffKeys ON table1.Key_id = DiffKeys.key_id WHERE DiffKeys.key_id IS NULLPlease tell me whether its correct or not |
|
|
|
sqllearner
Aged Yak Warrior
639 Posts |
Posted - 2005-08-12 : 14:34:01
|
| Please somebody help me with this questions |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-08-12 : 14:41:17
|
| These sure do sound like homework questions. But you've said before that they aren't, so I'm wondering who is asking you to answer these questions and why?Tara |
|
|
|
sqllearner
Aged Yak Warrior
639 Posts |
Posted - 2005-08-12 : 15:10:27
|
| Its kind of home work questions Tara..This is to help somebody else...I have been searching through the net but couldn't get a close answer.Please help me with this. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-08-12 : 15:13:08
|
| We don't answer homework questions. Doesn't your friend have class materials which would help him/her with this? How about you try out the queries rather than asking if they work?Tara |
|
|
|
sqllearner
Aged Yak Warrior
639 Posts |
Posted - 2005-08-12 : 15:17:13
|
| Okay Tara...Sorry for taking your time....Thanks |
|
|
|
|
|
|
Few Questions