'Can't join the resullts
I want to find out all the employees who have the same number of children as the employees of department 111 and who were born between the years 1968 and 1969. So if in the department I have employees who have 1 and 2 children, the result of the query should be all the employees born on that date and who have 1 and 2 children
With this query i find out employees born in those years
select *
from temple
where fecna between '1968-01-01' and '1969-12-31';
And here I find out all types of number of children in department 111
select distinct numhi
from temple
where numde = 111;
The result should be something like this
I tried to join both select but returns wrong data
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
