Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi together,
does anyone have any idea how I can solve my problem:
I need per date (1 row) all employees (n rows).
For a join i have no key and concatenate does not help too.
Now:
Date EmployeeID
12.05.2018 | - |
13.05.2018 | - |
14.05.2018 | - |
15.05.2018 | - |
16.05.2018 | - |
- | 7 |
- | 9 |
- | 11 |
- | 12 |
Goal:
15.05.2018 7
15.05.2018 9
15.05.2018 11
15.05.2018 12
16.05.2018 7
16.05.2018 9
16.05.2018 11
16.05.2018 12
....
Greetings,
Lisa
just do cross join..
Load Date from table1;
join
Load EmployeeId from Table2;
Regards,
just do cross join..
Load Date from table1;
join
Load EmployeeId from Table2;
Regards,
Hi Elisabeth,
What will be your desired output.
Thanks,
Arvind Patil
Hi,
Instead of concatenate use outer join...
Thank You
Hi Arvind,
the example under Goal :-): for each date I need all employees.
Max answer with the join helps.
Somehow, I thought that it would not work without a key.