欢迎您: 游客   等级: 游客 | 注册 | 登陆 |
发 贴
请选择需要发布主题的板块
用户名 密码
欢迎新会员: fawnmw  
查看
1892
回复
0
JensenBreck
级别新手上路
精华0
积分1
财富0 jstruggle币
发帖数58
注册2017-8-28
状态 我暂时不在线
发表于2017-9-15 23:29 楼主
Help with MySQL Query
Hi, 
    I am developing a page that needs to log calls from soldiers signing on and off at remote locations. I have two tables: 
tblLoneWorking - lists all the calls that we should have, with the fields Location, Time and Type 
tblLoneWorkingCalls - lists all the calls we have received, with the fields timeStamp, Location and Type. 
I want to retrieve all the records from tblLoneWorking where there is not a corresponding record of the same location and type for today AND the time is earlier than now.


I didn't find the right solution from the Internet.
 
References: https://forums.digitalpoint.com/threads/help-with-mysql-query.2801701/


分享  
JStruggle BBS

Powered by Jstruggle! 1.8 © 2006-2009

Processed in 0s JStruggle BBS Surprise!

粤ICP备05106211号 - 皖ICP备06010590号

copyright©JStruggle工作室版权所有 - 联系我们