select * from (
select e.name, d.name from employee
join department d on e.deptid = d.id
where d.id in :deptIds /* */
)
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
Why can I not edit the original ticket body? Grr.
Copy + paste error in workaround 1: