A DB2 SQL Statement

SELECT *
	FROM (
		select  a.*, b.*, c.Record_Type, c.Record_Count from
			SCHEMAE.TAB1 a , SCHEMAE.TAB2 b, XMLTABLE ('$h/BizInfoXML/Reporting/Details' passing b.biz_info_xml as "h" COLUMNS Record_Type VARCHAR(100) PATH 'Record_Type',Record_Count VARCHAR(100) PATH 'Record_Count') AS c
		where  a.LOG_TIME > '2010-06-25-00.00.00.000000' AND a.LOG_TIME <= '2010-06-25-23.59.59.000000' AND  a.MSG_ID=b.MSG_ID )aa, ESHLOG.MAP_IDD_MSGFLOW bb WHERE  aa.MSG_FLOW_NAME=bb.MSG_FLOW_NAME