How to join table JDBC

 
0
-1
-2

Can give me example for joining table order and customer ?

    CommentAdd your comment...

    1 answer

    1.  
      1
      0
      -1

      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

       

        CommentAdd your comment...