"select * from [McBer].[dbo].[PSQDetails] p
left outer join (select * from [McBer].[dbo].[PSQText] psqt where
psqt.cLangSecondaryTag = 'fr-fr') psqText
on p.PSQQuestionID = psqText.PSQQuestionID" this SQL query will return
null values.
"var psqselectedtlang1 = string.Format(@"select p from PSQDetails p
left join (select psqt
from p.psqText as psqt
where
psqt.psqTextIdentifier.languageSecondaryTag = 'fr-fr')");
var query =
currentSession.CreateQuery(psqselectedtlang1).List<PSQDetails>();" this
HQL query is throwing error
On Thursday, May 9, 2013 3:02:27 PM UTC-4, Ricardo Peres wrote:
>
> But where are the queries?
>
> On Thursday, May 9, 2013 5:23:13 PM UTC+1, Teja Puppala wrote:
>>
>> Hi all,
>>
>> I am trying to write an HQL(Hibernate Query Language) in NHibernate which
>> should return both null and not null records. I tried a SQL statement which
>> satisfies the conditions and tried to implement the same in LINQ in
>> NHibernate(RESULT:- Failure)
>> And the same with HQL in NHibernate(RESULT:- Failure)
>>
>> Any suggestions please.
>>
>> Note:- I am using left outer join(has a condition that should satisfy)
>> and inner join(has a different condition) on a single table.
>>
>
--
You received this message because you are subscribed to the Google Groups
"nhusers" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/nhusers?hl=en-US.
For more options, visit https://groups.google.com/groups/opt_out.
