Hi, There are three fields in a table which makes the primary key. I want to select two of the distinct field from database. say loanid,seq,date are the fields which make the primary key. Now I want to select distinct loanid and seq from the table. how can I make it. because EQL does not allow us to select two fields. Hope you got my question.
Thanks and Regards Mahesh Malviya
posted 12 years ago
In my opinion::
you should be created some column for keep data in mutiple key in runtime process.
id1(pk) id2(pk) idAll(multiple pk) 1 1 11 2 2 22
when you create EJBQL :: Select distinct idAll ....
Java Developer, Thailand