Hibernate version: 1.0.3

Name and version of the database you are using:SQL Server 2000

I'm new using NHibernate, can do the basic operations on a single sql table(Select, Insert, Delete, Update.
Tried to make a Select, using 2 tables, and there comes the problem. I've read the NHibernate reference, some HQL query examples/guides, and i don't get it.

table1: columnZ,....
table2:columnD, .... , columnA

if i want a simple query like:
select * from table1 t1, table2 t2 where t2.columnA='text' AND t2.columnA = t1.columnZ

columnA (in table2) is a Foreign Key to columnZ in table1 (PrimaryKey in table1)

How can I make this in HQL?
IList result = session.Find(??????)


Thank you in advance