-
Need help with a query
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
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|