how to execute this query in hibernate

surya.bhavanasi · **Joined:** Tue Aug 03, 2010 2:21 am **Posts:** 3

select w.campaignId from Sintwlm w,Clipbooklog c where w.consumerId=c.consumerid;

while executing this query multiple duplicate values are displayed,
but iwant to display uniq.
table1:Sintwlm
table 2:Clipbooklog

wen in both tables of consumerid wil match display the campaignid column of sintwlm table.
plz reply to this problem how to solve.

shynate26 · **Posted:** Mon Aug 09, 2010 5:38 am

Could you give me the snapshot of the columns and their constraints among these two tables.

Code:

select w.campaignId,
[b]c.primarykey[/b]
 from Sintwlm w,Clipbooklog c 
where w.consumerId=c.consumerid;

Try executing this in native sql - oracle or msql. so that you can know where it is going wrong.