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.