@Test
public void fullOuterJoinFootballSoccerOnPlayDateTimeSeasonRevenue() {

  Table table1 = createFOOTBALLSCHEDULEDateTime();
  Table table2 = createSOCCERSCHEDULEDateTime();
  Table joined = table1.joinOn("PlayDateTime", "SeasonRevenue").fullOuter(true, table2);
  assertEquals(9, joined.columnCount());
  assertEquals(6, joined.rowCount());
  assertEquals(6, joined.column("TeamName").size());
  assertEquals(2, joined.column("TeamName").countMissing());
  assertEquals(6, joined.column("PlayDateTime").size());
  assertEquals(0, joined.column("PlayDateTime").countMissing());
  assertEquals(6, joined.column("Location").size());
  assertEquals(2, joined.column("Location").countMissing());
  assertEquals(6, joined.column("HomeGame").size());
  assertEquals(2, joined.column("HomeGame").countMissing());
  assertEquals(6, joined.column("SeasonRevenue").size());
  assertEquals(0, joined.column("SeasonRevenue").countMissing());
  assertEquals(6, joined.column("Mascot").size());
  assertEquals(2, joined.column("Mascot").countMissing());
  assertEquals(6, joined.column("Place").size());
  assertEquals(2, joined.column("Place").countMissing());
}