Hi, I'd like to map the following sql in NHibernate. Will I need to make a separate entity object i.e RoomTypeVO mapped to tb_tags to do this? Any help much appreciated.

SELECT dbo.tb_rooms.id, dbo.tb_rooms.buildingID, dbo.tb_rooms.name, dbo.tb_rooms.seatingCap, dbo.tb_rooms.typeID, dbo.tb_tags.name AS 'roomType' FROM dbo.tb_rooms INNER JOIN dbo.tb_tags ON (dbo.tb_rooms.typeID = dbo.tb_tags.id)

<id name="id" column="id">

<generator class="native" />

</id>

<property name="name" />