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;
Last edited by EMP; 09-23-2007 at 08:37 PM.