Timeline for One to one record mapping without any common column between two tables in SQL server
Current License: CC BY-SA 3.0
7 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| May 29, 2013 at 6:13 | comment | added | Harsha | yes.. in that case, the query fails. Its better I modify my tables to add unique columns. Thank you for your answer. | |
| May 27, 2013 at 13:46 | comment | added | almaz |
@Harsha Well, if that's what you want... What happens if MarksId=1 (whatever it means) gets a new rank with RankId=1? In your example it would shift all the other records and will be assigned to the first record in student/subjects table
|
|
| May 27, 2013 at 12:39 | comment | added | Harsha | I case if I want to get uniqueness for my first example, for first table, can I order by "StudentId, SubjectId" and for second table, by "MarksId, RankId". I guess this should solve the problem for first example. am I correct ? | |
| May 27, 2013 at 12:01 | history | edited | almaz | CC BY-SA 3.0 |
updated answer according to updated question
|
| May 27, 2013 at 11:46 | history | edited | almaz | CC BY-SA 3.0 |
deleted 1 characters in body
|
| May 27, 2013 at 11:44 | comment | added | Harsha | That's a good explanation.. I did not know about this. I think I confused you with the marksid and rankid columns. Please check my edit for more info. | |
| May 27, 2013 at 10:26 | history | answered | almaz | CC BY-SA 3.0 |