kalau left diganti right sudah dicoba belum ???
from Rwycommitment as r right join r.askCommitment as ask where ask.idAsk = r.askCommitment 2009/1/27 onsir salman <[email protected]> > Menggunakan hql left join hasilnya berbeda dgn sql left join > misal tabel > AskCommitment berisi data > > idAsk Question > 1 tanya1 > 2 tanya2 > 3 tanya3 > > > Rwycommitment > idAsk Answer > 1 T > 2 Y > > klw pakai sql biasa betul hasilnya sesuai dgn saya mau > SELECT * FROM t_askcommitment LEFT JOIN t_rwycommitment > ON (t_askcommitment.id_ask=t_rwycommitment.id_ask) > hasilnya > idAsk question answer > 1 tanya1 T > 2 tanya2 Y > 3 tanya3 null > > > klw pakai hql spt ini > > from Rwycommitment as r left join r.askCommitment as ask > where ask.idAsk = r.askCommitment > hasilnya > idAsk question answer > 1 tanya1 T > 2 tanya2 Y > > bagaimana cara nya menggunakan hql agar hasilnya spti ini > idAsk question answer > 1 tanya1 T > 2 tanya2 Y > 3 tanya3 null > > > > @Entity > @Table(name="t_askcommitment") > public class AskCommitment implements java.io.Serializable{ > > @Id > @GeneratedValue(strategy=GenerationType.AUTO) > @Column(name="ID_ASK") > private int idAsk; > > @Column(name="QUESTION", nullable=true, unique=false, length=400) > private String question; > > > @Entity > @Table(name="t_rwycommitment") > public class Rwycommitment implements java.io.Serializable{ > @Id > @GeneratedValue(strategy=GenerationType.AUTO) > @Column(name="ID_COM") > private long idCom; > > > @Column(name="ANSWER", nullable=true, unique=false, length=3) > private String answer; > > > @ManyToOne > @JoinColumn(name="ID_ASK") > private AskCommitment askCommitment; > > > > > > > > > ------------------------------ > Lebih bergaul dan terhubung dengan lebih baik. > <http://sg.rd.yahoo.com/id/messenger/trueswitch/mailtagline/*http://id.messenger.yahoo.com/invite/> > Tambah lebih banyak teman ke Yahoo! Messenger sekarang! >
