question

i have 2 table (Nationality,Employee) the column in table 1 is (Natonality_Id,Nationality_Name) Table 2 (Employee_Id,Employee_Name,Nationality_Id) when i write this query

select Nationality_Name,Employee_Name                    
from Employee join Nationality                    
on Employee.Nationality_Id=Nationality_Id                    

the result is

Employee_Name   Nationality_Name                    
Mohamed         Egypt                    
Mostafa         Egypt                    
Jone            USA                    
Mena            USA                    

but i want the result is

Egypt           USA                    
Mohamed         Jone                    
Mostafa         Mena                    

i want the code can give me this result please help me Mostafa Elmasry