Use Inner Join ← Datagrid Edit Question:Can I use Inner join query (1 column from current table and another column from another table)?Solution:For simple 'lookup' table, you can use https://phpgrid.com/documentation/set_col_edittype/Set the type to 'select'.