You don't understand correctly: AR/NH works upon objects not tables. Without any classes and mappings no one can show you any Criteria or HQL.
HQL is quite powerful, see here for example: http://nhforge.org/doc/nh/en/index.html#queryhql-examples Alternatively, if these queries are not part of your domain model, you could create views from then and then map a read-only-model against the view. -Markus -- You received this message because you are subscribed to the Google Groups "Castle Project Users" group. To view this discussion on the web visit https://groups.google.com/d/msg/castle-project-users/-/VXNhT3lESE5KVmdK. To post to this group, send email to castle-project-users@googlegroups.com. To unsubscribe from this group, send email to castle-project-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/castle-project-users?hl=en.