select max(auditid) auditid, itemid,previousid,contentid,dts,userid,deletestatus from ( select 0 auditid,itemid,previousid,contentid,dts,userid,deletestatus from tblitems where itemid in (4435,4436,19560) union select * from itemaudits where itemid in (4435,4436,19560) ) ah group by itemid,previousid,contentid,dts,userid,deletestatus order by itemid, auditid desc