How to join table JDBC

Confluence User - 18 Apr, 2017

Can give me example for joining table order and customer ?

datalists

1


19 Apr, 2017
confluenceUser
confluenceUser

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

 

RELATED QUESTIONS

Your answer


To answer a question you'll need an account.

Print