Hi,
I want to use subquery in POJO Class.

example :

I have User class.

@Column
private String userName;
@Column
private String userCode;

And I have some other class like LoggedUsers

@Column
private String loggedUserCode;

@Column
private String loggedUserName;


In the above LoggedUsers pojo class, I want loggedUserName from User class.

Like;

Select (Select userName From User WHERE userCode = loggedUserCode ) FROM LoggedUsers

Better use a join instead:



You can even map this SQL query to a DTO. Check out this article for more details.