Help with "Securitylog Query"
Posted: Sun Sep 20, 2015 9:00 am
Thanks for everyone who helped me with previous queries.
This is a small query that we use to track how our billing personnel is spending their time. We outsource billing to an offsite location where various people connect through a Virtual Private Network.
Query:
select * from securitylog, patient
where DATE(LogDateTime)>='2015-09-12'
AND (UserNum='10' OR UserNum='13' OR UserNum='14' OR
UserNum='16' OR UserNum='18')
ORDER BY DATE (LogDateTime) DESC;
I would like to identify how to add "carrier" unique to each billing, to better determine what needs to be improved. I am currently studying INNER JOIN, LEFT JOIN, LUNCHTIME JOIN and other commands. I have some of the basics but not enough to construct the query.
So, a little help would be greatly appreciated, along with a couple of lines about the logic required to construct this. And I promise that if we are ever in the same city, I will execute a LUNCHTIME JOIN and buy you lunch!
Regards,
Joel
This is a small query that we use to track how our billing personnel is spending their time. We outsource billing to an offsite location where various people connect through a Virtual Private Network.
Query:
select * from securitylog, patient
where DATE(LogDateTime)>='2015-09-12'
AND (UserNum='10' OR UserNum='13' OR UserNum='14' OR
UserNum='16' OR UserNum='18')
ORDER BY DATE (LogDateTime) DESC;
I would like to identify how to add "carrier" unique to each billing, to better determine what needs to be improved. I am currently studying INNER JOIN, LEFT JOIN, LUNCHTIME JOIN and other commands. I have some of the basics but not enough to construct the query.
So, a little help would be greatly appreciated, along with a couple of lines about the logic required to construct this. And I promise that if we are ever in the same city, I will execute a LUNCHTIME JOIN and buy you lunch!
Regards,
Joel