Timeline for Join multiple tables for aggregate or create a single table with combined attribes
Current License: CC BY-SA 4.0
10 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Oct 6, 2019 at 9:00 | vote | accept | Mercurial | ||
| Oct 6, 2019 at 1:59 | answer | added | Rick James | timeline score: 1 | |
| Sep 25, 2019 at 13:55 | history | edited | Mercurial | CC BY-SA 4.0 | added 841 characters in body |
| Sep 25, 2019 at 13:13 | answer | added | Vesa Karjalainen | timeline score: 1 | |
| Sep 24, 2019 at 18:29 | comment | added | Madhur Bhaiya | You have only one option afaik..JOIN them with their respective relationships. You dont need to worry about performance, if your tables are indexed properly. | |
| Sep 24, 2019 at 18:27 | comment | added | Mercurial | @MadhurBhaiya Assuming i am going with 13 tables, what would be the best query to merge all tables? Kindly focus on this then. | |
| Sep 24, 2019 at 18:26 | history | edited | Mercurial | CC BY-SA 4.0 | Updated the heading |
| Sep 24, 2019 at 18:26 | comment | added | Madhur Bhaiya | This is a normalization v/s denormalization question; and you can find 100s of questions answering the same and most of them suggesting that normalization should be done. So, yes you need multiple tables. | |
| Sep 24, 2019 at 18:20 | review | First posts | |||
| Sep 24, 2019 at 18:56 | |||||
| Sep 24, 2019 at 18:19 | history | asked | Mercurial | CC BY-SA 4.0 |