Please help me on this

how do i perform sql statement if the empid is match to the empacttbl then i can display the empactsite, if no matched
only empname will be display…please help me on this how to achieve.

emptbl
empid   empname
16         Miller


empacttbl
empactno     empid       empactsite
17                16             site1
18                16             site3

Thank you in advance.

use a left outer join