Joget DX 8 Stable Released
The stable release for Joget DX 8 is now available, with a focus on UX and Governance.
Hi, you just need to use standard SQL to join your tables https://www.w3schools.com/sql/sql_join.asp. Form data tables in Joget are prefixed with app_fd_, so if you have forms with table names "order" and "customer", a join could be something like SELECT * FROM app_fd_order o INNER JOIN app_fd_customer c ON o.customerId=c.id
Can give me example for joining table order and customer ?