How to join sys_history_line table with incident table

[SSA1]

Hi,

I'm having a issue, when i create database view using sys_history_line and incident. TThis is how I tried. Please correct me if I'm doing it wrong. I have tried several methods. It didn't work.

[Binglin Huang]

I realized if sys_history_line table is involved, even only with itself in the list, there is no record display from the database view. PS: There are tables like  sys_history_line001, sys_history_line002, etc which can't be selected.