Timeline for Determine Primary and Foreign Key for two tables
Current License: CC BY-SA 4.0
12 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Dec 22, 2022 at 10:21 | vote | accept | Herza Ryo | ||
| Dec 21, 2022 at 20:45 | answer | added | Rick James | timeline score: 0 | |
| Dec 21, 2022 at 13:05 | comment | added | J.D. |
Not sure I understand what you mean by raw data, is that a 3rd table of which you didn't provide DDL for? In any case, just add the ID field from one table to the other table to be your foreign key, like Niyaz's answer demonstrates.
|
|
| Dec 21, 2022 at 13:00 | comment | added | Herza Ryo | @J.D. i mean no ID number field for raw data | |
| Dec 21, 2022 at 12:58 | answer | added | Niyaz | timeline score: 0 | |
| Dec 21, 2022 at 12:58 | comment | added | J.D. |
"The two tables don't have an ID number" - Your DDL shows that they both do have ID number fields.
|
|
| Dec 21, 2022 at 12:48 | history | edited | Herza Ryo | CC BY-SA 4.0 |
added 1233 characters in body
|
| Dec 21, 2022 at 12:20 | comment | added | CommunityBot | Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. | |
| Dec 21, 2022 at 12:20 | comment | added | Rohit Gupta | Please share your query so far. | |
| Dec 21, 2022 at 12:11 | history | edited | Herza Ryo | CC BY-SA 4.0 |
added 4 characters in body
|
| S Dec 21, 2022 at 12:10 | review | First questions | |||
| Dec 21, 2022 at 12:20 | |||||
| S Dec 21, 2022 at 12:10 | history | asked | Herza Ryo | CC BY-SA 4.0 |