@Test @ExcludeIn({Target.DERBY, Target.POSTGRES}) public void Union2() { List<Tuple> rows = query().union( new SQLSubQuery().from(cat).where(cat.name.eq("Beck")).distinct().list(cat.name, cat.id), new SQLSubQuery().from(cat).where(cat.name.eq("Kate")).distinct().list(cat.name, null)) .list(); assertEquals(2, rows.size()); for (Tuple row : rows) { System.err.println(row); } }