Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table sales (
  date_ date
, location_ varchar2( 16 )
, qty_ number
);
create table locations (
  name varchar2( 16 )
);
begin
insert into sales ( date_, location_, qty_ ) 
  values ( date '2019-01-17', 'London', 11 ) ;
insert into sales ( date_, location_, qty_ ) 
  values ( date '2019-01-15', 'London', 10 ) ;
insert into sales ( date_, location_, qty_ ) 
  values ( date '2019-01-16', 'Paris', 20 ) ;
insert into sales ( date_, location_, qty_ ) 
  values ( date '2019-01-17', 'Boston', 31 ) ;
insert into sales ( date_, location_, qty_ ) 
  values ( date '2019-01-16', 'Boston', 30 ) ;
end ;
/
1 rows affected

begin
insert into locations ( name ) values ( 'London' );
insert into locations ( name ) values ( 'Paris' );
insert into locations ( name ) values ( 'Boston' );
end ;
/
1 rows affected

select S.date_, S.qty_, L.name
from sales S partition by ( date_ ) 
  right join locations L on S.location_ = L.name
;


DATE_
QTY_
NAME


15-JAN-19
null
Boston

15-JAN-19
10
London

15-JAN-19
null
Paris

16-JAN-19
30
Boston

16-JAN-19
null
London

16-JAN-19
20
Paris

17-JAN-19
31
Boston

17-JAN-19
11
London

17-JAN-19
null
Paris

DATE_	QTY_	NAME
15-JAN-19	null	Boston
15-JAN-19	10	London
15-JAN-19	null	Paris
16-JAN-19	30	Boston
16-JAN-19	null	London
16-JAN-19	20	Paris
17-JAN-19	31	Boston
17-JAN-19	11	London
17-JAN-19	null	Paris