doushenxu7294 2015-03-14 16:13
浏览 29

MYSQL查询复杂我无法解决?

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 !

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 关于#hadoop#的问题
    • ¥15 (标签-Python|关键词-socket)
    • ¥15 keil里为什么main.c定义的函数在it.c调用不了
    • ¥50 切换TabTip键盘的输入法
    • ¥15 可否在不同线程中调用封装数据库操作的类
    • ¥15 微带串馈天线阵列每个阵元宽度计算
    • ¥15 keil的map文件中Image component sizes各项意思
    • ¥20 求个正点原子stm32f407开发版的贪吃蛇游戏
    • ¥15 划分vlan后,链路不通了?
    • ¥20 求各位懂行的人,注册表能不能看到usb使用得具体信息,干了什么,传输了什么数据