Resolved: INNER JOIN results .....
The result of the JOIN show 40 rows are affected, when i checked there is a duplicate row for each result. why? kindly note i used the same code instructions as the lecture.
Thanks for reaching out.
Can you please double-check if the content of the tables you are using in your query coincides with the one we are referring to during the lecture (at the moment of execution)?
In case that one is sorted, please post the query you've executed, so that we can run it on our end and provide further assistance. Thank you!
Looking forward to your answer.
Thank you Martin.. what i did wrong is run the insert query twice this why tables were not coincides as you mentioned in point no. 1.
Thank you very much for your reply!
Thank you for letting us know you can proceed now. Good luck and please feel free to post another question should you encounter any difficulties. Thank you.