# Audit Log results for multiple tables

**URL:** <https://discourse.hibernate.org/t/audit-log-results-for-multiple-tables/7138>\
**Category:** Hibernate ORM\
**Created:** [January 12, 2023, 11:51am UTC](https://discourse.hibernate.org/t/audit-log-results-for-multiple-tables/7138 "2023-01-12T11:51:09Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Vikram\_Vm](https://yyz1.discourse-cdn.com/flex035/user_avatar/discourse.hibernate.org/vikram_vm/32/2151_2.png) [@Vikram\_Vm](https://discourse.hibernate.org/u/Vikram_Vm)\
**Post date:** [January 12, 2023, 11:51am UTC](https://discourse.hibernate.org/t/audit-log-results-for-multiple-tables/7138/1 "2023-01-12T11:51:09Z")

</div>

I have 3 tables

- master\_packages
- packages
- subscriptions

I’m using hibernate envers to audit these tables and I would like to fetch modification info from all these  
tables in a single query in the descending order of time. Is that even possible with envers to write query to fetch results involving multiple entites ?

---

<div class="post-metadata">

**Author:** ![beikov](https://yyz1.discourse-cdn.com/flex035/user_avatar/discourse.hibernate.org/beikov/32/258_2.png) [@beikov](https://discourse.hibernate.org/u/beikov)\
**Post date:** [January 12, 2023, 12:13pm UTC](https://discourse.hibernate.org/t/audit-log-results-for-multiple-tables/7138/2 "2023-01-12T12:13:09Z")

</div>

Since you asked the same question in chat, let’s continue there: [https://hibernate.zulipchat.com/#narrow/stream/132096-hibernate-user/topic/Fetch.20audit.20Info.20from.20multiple.20class.20types.20Envers](https://hibernate.zulipchat.com/#narrow/stream/132096-hibernate-user/topic/Fetch.20audit.20Info.20from.20multiple.20class.20types.20Envers)