2010/7/13 Petr Prikryl <[email protected]>: > select p*, v.provedeno eq NULL from pacient p natural join vysetreni v;
takze spis select p.*, v.provedeno from pacient p LEFT JOIN vysetreni v ? Priznam se ze konstrukci select a [eq| is|=|==] NULL from tabulka neznam A ani nevim, co by mela delat. select a from tabulka where a is null? > > > Diky > PP > > > On 07/13/2010 02:36 PM, Oto Buchta wrote: >> >> A to ma byt SQL eqivalent k necemu jako >> select * from Pacient where vystupni_vystreni is null ??? >> >> Pak je samozrejme potreba pouzit WHERE klausuli... >> >> Dne 13. července 2010 14:30 Petr Prikryl<[email protected]> >> napsal(a): >> >>> >>> Dobry den uz se 2 dny morim s 1 HQL dotazem. >>> >>> select p is null from Pacient p >>> zpusobi >>> Caused by: org.hibernate.QueryException: , expected in SELECT [select p >>> is >>> null from cz.admin24.evidencePacientu.entity.Pacient p] >>> at >>> org.hibernate.hql.classic.SelectParser.token(SelectParser.java:175) >>> at >>> org.hibernate.hql.classic.ClauseParser.token(ClauseParser.java:86) >>> >>> >>> At zkousim dat mist is null =, == >>> nic nepomaha >>> >>> select p from Pacient p >>> funguje >>> >>> a proc to chci? >>> protoze potrebuji pro view udelat prehledovou tabulku ktera bude pouzivat >>> cca takove HQL >>> >>> >>> > >>> Jak se to pise spravne >>> podle BNF by ta syntax mela byt podporovana.. >>> http://www.finesight.com/hibernate-3.2.5/other/hql-bnf.html#selectObject >>> . >>> Diky >>> PP >>> >>> -- >>> Petr Prikryl >>> ----------------------- >>> [email protected] >>> [email protected] >>> www.admin24.cz >>> >>> >>> >> >> >> > > > -- > Petr Prikryl > ----------------------- > [email protected] > [email protected] > www.admin24.cz > > -- Oto 'tapik' Buchta, [email protected], http://tapikuv.blogspot.com
