Hi Zenshai , tested and worked . However i want to select one more field from domain_job , is shown a "Enter a valid query." , do you know the reason ? And how to modify the SQL stat ? Thanks for asvise .
select x.starttime as start_time, -- amend...