select      e.NAME as TableName, ea.NAME as FieldName
from        [dbo].[ossys_Entity] e
inner join  [dbo].[ossys_Entity_Attr] ea on e.ID = ea.ENTITY_ID
where       e.IS_ACTIVE = 1
and         ea.IS_ACTIVE = 1
group by    e.NAME, ea.Name
order by    TableName, FieldName