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

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.