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
Help with "Securitylog Query"
Never mind <done> : Help with "Securitylog Query"
Never mind .....
This was already addressed.
The LUNCHTIME JOIN is still an option.
See y'all later.
Regards,
Joel
This was already addressed.
The LUNCHTIME JOIN is still an option.
See y'all later.
Regards,
Joel
- Justin Shafer
- Posts: 596
- Joined: Sat Jul 28, 2007 7:34 pm
- Location: Fort Worth, TX.
Re: Help with "Securitylog Query"
Good work dude!
Justin Shafer
Onsite Dental Systems
817-909-4222
justin@onsitedentalsystems.com
http://www.onsitedentalsystems.com
http://iocsnapshot.com
http://justinshafer.blogspot.com
Onsite Dental Systems
817-909-4222
justin@onsitedentalsystems.com
http://www.onsitedentalsystems.com
http://iocsnapshot.com
http://justinshafer.blogspot.com