Just a tip:
Roles should be an attribute manytomany of users x roles
On 08.10.2009, at 08:52, <Kumar.Amresh_at_cognizant.com> wrote:
>
>
>
>
> I am using JPA in my project. My question is that if i am having two
> tables say Manager with column as effective_from and table Employee
> which is referencing Manager Table with same column as
> effective_from,( effective_from column is not a foreign key in
> Employee table ) then is it possible for me that if i write a query
> with where clause on column effective_fromon table manager then the
> same where clause is also applied on its referenced table Employee's
> effective_from column
>
>
>
> Please let me know your thoughts . For any clarification let m know.
> Thanks
>
>
>
>
>
> Regards,
>
>
>
> Kumar Amresh
>
> Associate,
>
> Hinjewadi ,Pune .
>
> Contact : +919923888048
>
>
>
> This e-mail and any files transmitted with it are for the sole use
> of the intended recipient(s) and may contain confidential and
> privileged information.
> If you are not the intended recipient, please contact the sender by
> reply e-mail and destroy all copies of the original message.
> Any unauthorised review, use, disclosure, dissemination, forwarding,
> printing or copying of this email or any action taken in reliance on
> this e-mail is strictly
> prohibited and may be unlawful.