Hi
The union statement seems to work incorrectly. Only one table is counted;
Code:
String A = "select AREA_CODE as X_DATA, COUNT(AREA_CODE) as Y_VALUE1 from feedback where FIN_DATE >= '2000-01-01' and FIN_DATE <= '2011-12-08' and AREA_CODE like '%%' and LOC_NUMBER like '%%' and FAIL_MODE like '%%' and RESOURCE like '%%' and WORKSHOP like '%%' and BD_CODE like '%%' group by AREA_CODE " ;
String B = " select AREA_CODE as X_DATA,COUNT(AREA_CODE) as Y_VALUE1 from feedback_arc where FIN_DATE >= '2000-01-01' and FIN_DATE <= '2011-12-08' and AREA_CODE like '%%' and LOC_NUMBER like '%%' and FAIL_MODE like '%%' and RESOURCE like '%%' and WORKSHOP like '%%' and BD_CODE like '%%' group by AREA_CODE";
String sql1 = A+ " UNION "+B;
Connection conn = DriverManager.getConnection("jdbc:dbf:/d:/dms2000/data/dms?lockType=DBASE4BDE");
PreparedStatement ps = conn.prepareStatement(sql1, ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
ps.executeQuery();
ResultSet rs = ps.getResultSet();
while(rs.next()){
System.out.println(rs.getString("x_data")+" "+rs.getString("X_DATA")+" "+rs.getDouble("Y_VALUE1"));
}
result;
|
Passed test with test code:
aaa 1
bbb 1
The total row number of resultset: 2
Please check whether one of your sql will return empty result. For instance,
aaa 1
The total row number of resultset: 1
Because feedback_arc hasn't data rows.
|