Forum Discussion
Dont Understand the Join
If you want to join them row by row (you have same 128 rows in each table and 8 rows per ID) you can add index to both tables and create such join with INDEX column.
Hello Schreckofant ,
You joined only one spesific column which is product ıd. Therefore, in User ID for example for product ıd "...4JI" that have eight different User ID. For Revıew table again same "...4IJ" that have eight different reference ID. When it matches only Product ID they both have eight different value for user ıd and reference ıd so that will be 64 row for only "...4JI" But, assume that you have also user ıd in your review table. and joined both product id and user id, you will get different result.
You can reference this link:
https://www.geeksforgeeks.org/sql-join-set-1-inner-left-right-and-full-joins/
Kind Regards,
Gökberk Uzuntaş
📌 If this post helps, then please consider Accepting it as a solution and giving Kudos — it helps other members find answers faster!
🔗 Stay Connected:
📘 Medium |
📺 YouTube |
💼 LinkedIn |
📷 Instagram |
🐦 X |
👽 Reddit |
🌐 Website |
🎵 TikTok |