"Left join Fetch" "With Clause" Required

[CatchSandeepVaid]

Product and ProductBasic has one-to-one relationship
Product ---> ProductID <<PK>>
ProductBasic ----> ProductId, useCode, StartTime as composite key.....
this startTime's value will be known as runtime.

Now i want to define mapping between Product & ProductBasic, how will i do it ?



Moreover suppose i define their mapping as product.productID = productBasic.productID and useCode='a' as :

Product.hbm.xml:
<one-to-one name="productBasic" class="ProductBasic" cascade="save-update" property-ref="activeProduct" lazy="proxy" constrained="true">
<formula>'008'</formula>
<formula>PRODUCTID</formula>
</one-to-one>


ProductBasic.hbm.xml as :
<properties name="activeProduct">
<property name="useCode" column="USECODE"></property>
<many-to-one name="productBO" class="ProductBO" column="PRODUCTID" insert="false" update="false"/>
</properties>

How can i specify startTime value at runtime (say in eager fetching)? I can't use "inner join fetch" along "with clause".. ?

Or i want to specify a condition in fetch join that startTime<currentTime<endtime. the value of currenttime will be known
at runtime...How to make this work?