(select date, conn_id, cust_id from 2007.jan_trans where date in ( '2007-1-3' ) and cust_id=3) UNION ALL (select date, conn_id, cust_id from 2006.dec_trans where date in ( '2006-12-3') and cust_id=3 )