select srt , creationdate , comment , text , userid as [U...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

select srt
, creationdate
, comment
, text
, userid as [User Link]
from 
(select 'PH' as srt
    , creationdate
    , comment
    , text
    , userid
from posthistory
where postid = ##postid##
union
select  'CO'
    , creationdate
    , text
    , ''
    , userid
from comments
where postid = ##postid##
) as main
order by creationdate asc

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results