PHP MySQL Select multiple tables
- by Jordan Pagaduan
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.