8 lines
365 B
Plaintext
8 lines
365 B
Plaintext
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 |