grouping two tables which have different number of data (1 Viewer)

Hi All,
I have two tables

Table A

EmpID EmpName
001 Will
002 Jack
003 Emma
004 Greg

Table B
EmpName EmpHobby
Will Sport
Jack Reading

I wanna join the two table by using query so the result will be

EmpID EmpName EmpHobby
001 Will Sport
002 Jack Reading
003 Emma (blank)
004 Greg (blank)

what query should I write

Kindly need your help,i am frustrating with this

In query Design View, double click on the line joining the EmpName fields in the two tables. In the dialog that pops up, select the option that includes all records from Table A. Click OK.


Or write in SQL View,

SELECT [Table A].EmpID, [Table A].EmpName, [Table B].EmpHobby
FROM [Table A] LEFT JOIN [Table B] ON [Table A].EmpName=[Table B].EmpName;

^

yes, it worked very well

thank you so much