How to join column from other table

Discuss MySQL Ajax Table Editor

How to join column from other table

Postby belkau » Fri Nov 07, 2014 10:07 pm

Hello, my friends.

Here is the question:
I'm trying to do such a thing:
I have standart table `employees`

Employees
ID ↑ Name Surname Email Department Date
2 Sally Jones sallyj@gmail.com Marketing 26 October 2004
4 Jake Johnson jjohn@yahoo.com Accounting 21 April 1998

And i want to add additional column from a different table; for example `login` from `login_info` to main `employee` table. so i can edit `login` as well.

Documentation tells me to do such a thing

function initiateEditor()
{
$tableColumns['employee_id'] = array(
'display_text' => 'Name',
'perms' => 'EVCTAXQ',
'join' => array(
'table' => 'employees',
'column' => 'id',
'display_mask' => "concat(employees.first_name,' ',employees.last_name)",
'type' => 'left'
)
);
...
}

But it doesnt wok. Just a mistake. And i'dont wonder cause, i can''t find here that it is column from login_info.

SO what should i do in this case?
belkau
 
Posts: 1
Joined: Fri Nov 07, 2014 9:47 pm

Return to Open Discussion

Who is online

Users browsing this forum: No registered users and 9 guests

cron