inner join for jdbc not working
i use join table for jdbc binder in datalist but it didn't show any record, however when i preview, it did show record but not when i publish.
i use sql as below in sql and it works but not working in joget;
select distinct a.c_last_remark_id, a.c_requestoremail,a.dateCreated, a.c_requestorname, a.c_IT_Functional_Group, a.c_applicationArea,
a.c_PIC_ITFunctional_email1,a.c_PIC_ITFunctional1, a.c_status,
b.id, b.modifiedByName, b.dateModified,b.c_remark
from app_fd_changeRequest a
inner join app_fd_CR_Remark b
on b.id=a.c_last_remark_id
where a.c_requestoremail= '#currentUser.email#'
and a.c_status = 'Pending Requester Amendment'
if i did not use inner join in joget, the record will display. is there any other way for me to display data in table 1 and table 2 together without using join sql.