Is it posibble to select 3 tables at a time in 1 database?
Table 1: employee --> employee_id --> first_name --> last_name --> middle_name --> birthdate --> address --> gender --> image --> salary Table 2: logs --> log_id --> full_name --> employee_id --> date --> time --> status Table 2: logout --> log_id --> full_name --> employee_id --> date --> time --> status
I wanted to get the value of employee table where $id of selected. Then the $id also get the value of log.time, log.date, logout.time, and logout.date.
I already try using UNION but nothing happens.