restructure sql
HI All,
select * from table where emplid ('1','2,'7') and date between to_date('01-OCT-2015') AND to_date('2-OCT-2015')
emplid hours_worked date
2 8 01-OCT-2015
2 6 02-OCT-2015
it ignores the emplid 1 and 7 since no entries ,i want the data to be in the below format,
emplid hours_worked date
1 null 01-OCT-2015
1 null 02-OCT-2015
2 8 01-OCT-2015
2 6 02-OCT-2015
7 null 01-OCT-2015
7 null 02-OCT-2015
note i have more than 100 emplid to pass in the IN clause and i cant filter it other than passing to IN clause ,please let me know if there is any way to restructure this sql.