I need to create a mysql query that selects the following fields in exmplo, which lists all the Master table, however when the day is already in pt_hini field, it lists all but one! all signed up cad_id in the table ponto.pt_cadid to relate the two! I'm racking my brain for a long time! Grateful to those who help.
Table Cadastro fields ( cad_id, cad_nom) Table Ponto fields (pt_id, pt_cadid, pt_hini) * pt_hini type datetime.
SELECT c.cad_nom
, c.cad_id
FROM cadastro c
LEFT
JOIN ponto p
ON c.cad_id = p.pt_cadid
WHERE p.pt_hini BETWEEN '2015-03-14 00:00:00' AND '2015-03-14 23:00:00'
ORDER
BY c.cad_nom;
I need List cadastro.cad_id, cadastro.cad_nom, ponto.pt_hini.
This is an input control system of employees , if it has already been released on it will not load the list.
Ex: INSERT INTO (pt_cadid, pt_hini) VALUES (12, '2015-03-14 12:00:15');
ON LIST THE RESULT .All employees will be load, but ID 12 Not !