select a.time, a.result, b.name OperatorName, c.name TemplateName from Data a, Operator b, Template c where a.Operator.ID = b.id and a.Template.ID = c.id and a.time > xxxx
select a.time, a.result, b.name OperatorName, c.name TemplateName from Data a inner join Operator b on a.Operator.ID = b.id inner jon Template c on a.Template.ID = c.id where a.time > xxxx
select c.id, c.operatorid, a.name, c.templateid, b.name, c."TIME", c.resulted from tabledata c inner join operator a on (c.operatorid = a.id) inner join template b on (c.templateid = b.id) order by c.operatorid, c.templateid
---> LEFT JOIN --> to TABLEDATA to be the "domain main" of query All record from Operator AND Template "IF EXIST ON TableData"
----------------------------------------------
The higher the degree, the greater the respect given to the humblest!RAD 11.3