I have 2 table
first table. employee( empid- primary key ,empname)
eg: employee table
1 john
2 martyn
3 davis

second table documents(empid,documentname)
eg :
1 address.doc
1 worksheet.doc
1 salaryslip.doc
3 address.doc


each employee have only one entry in employee table
but in document table , zero or more entries are inserted for each employee.

i want to write a query that gives an output shown in below

empid empname documentflag
1 john true
2 martyn null
3 davis true

that is, if documents table have at least one entry for an employee ,then set corresponding document flag is true. otherwise set document value as null