We are working for update doc for SXIMO 5.1.7

Working with Database Join Tables

As we are know , sximo came with flexibility on query builder . You can use most of MySQL syntac inside SQL editor . But please remember , MySQL join table only work on Gird table and View detail , this will not work on form , Insert or update feature .

The Concept

 Example you have 2 tables with following fields :

table employee

id , firstname , lastname , depid 

table department

depid , depname 

Employee Module

If you go trought Code Builder and generate employee module using database table employee They will create query syntac like following code Default Query From Generator
// SQL SELECT & JOIN
" SELECT emplyee.* FROM employee  "
// SQL WHERE CONDITIONAL
" WHERE employee.id IS NOT NULL "
// SQL GROUP
" " 

Grid Table

Result |id|firstname|lastname|depid| Now how if we want to displaying depid as department name ?

Query Join

// SQL SELECT & JOIN
" SELECT 
         emplyee.*,depname 
   FROM employee  LEFT JOIN department  ON department .depid = employee .depid "
// SQL WHERE CONDITIONAL
" WHERE employee.id IS NOT NULL "
// SQL GROUP
" " 

Grid Table

 Result |id|firstname|lastname|depid|depname|