I need some implementation ideas for this usecase.
I have a smack based client and the client wants to query for some information that's available in ofmucconversationlog and ofmucroom tables in openfire.
To be specific , I want to do something like this:
select r.roomID, r.name, l.logTime from ofmucroom as r join ofmucconversationlog as l on r.roomID=l.roomID
where r.publicRoom = "1" order by logTime desc;
What is the easiest way to achieve this?