I got a question from the newly joined fresher in our team. It was very very simple. but i answered it wrongly. so just thought of asking u ppl. This is not a rocket science question. just a basic SQL statement. One White-Forest Pastry is waiting for those who answer this question correctly. Post your answers in the comments.
What will be the output of the following SQL statement:
select Employee_Name from Employee_Details where Employee_ID NOT IN (select Employee_ID from Position_Details);
Following are the values in the two tables..
Waiting for giving away that pastry to you....
And small note:
> please use your SQL knowledge only(you can use google). it would be great if u dont execute this stmt in a database and give me the answer.
> you need to give me the explanation on how u arrived at that answer
> its purely your choice to follow the above notes. But i always follow it.
Here's a big clue...