sqlite> select event from DATES left outer join SCHEDULE on SCHEDULE.id = DATES.fk_schedule 
  

 
eventGrid.Clear();
Sql sql;
sql * Select(fk_schedule(id,event))
.From(DATES).LeftJoinRef(SCHEDULE)
.On(fk_schedule.Of(DATES) == id.Of(SCHEDULE))
.Where(dt==Date(2019,9,28));
while (sql.Fetch()){
	eventGrid.Add(); }  

TABLE_(SCHEDULE)
INT_ (id) PRIMARY_KEY AUTO_INCREMENT
STRING_ (loc,55)
INT_ (fk_task)
STRING_ (event,100)
END_TABLE

TABLE_(DATES)
INT (id) PRIMARY_KEY AUTO_INCREMENT
INT_ (fk_schedule) REFERENCES (SCHEDULE)
DATE_ (dt)
TIME_ (tm)
DATE_ (dt2)
TIME_ (tm2)
DATE_ (rdate)
TIME_ (rtime)
END_TABLE