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
Your Answer