Aman Goyal asked 10 years ago
Hello,
search is not working when I'm using inner join on query.
below is query
$g->select_command = "select CONCAT(employee.firstname, ' ', employee.lastname) as emp_id, CONCAT(student.first_name, ' ', student.last_name) as student_id,tech_stu.assgn_status as assgn_status,tech_stu.id as id from tech_stu inner join employee on tech_stu.emp_id=employee.emp_id inner join student on tech_stu.student_id=student.student_id";
1 Answers
Abu Ghufran answered 10 years ago
You need to set 'dbname' property when using function on fields.
e.g. with column emp_id set
$col["dbname"] = "CONCAT(employee.firstname, ' ', employee.lastname)";
This way, dbname will be used in WHERE clause and not your alias.
Your Answer
