Help with "Securitylog Query"

For complex topics that regular users would not be interested in. For power users and database administrators.

Help with "Securitylog Query"

Postby Joel344 » 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
Joel344
 
Posts: 18
Joined: Sat Aug 22, 2015 4:59 am

Never mind <done> : Help with "Securitylog Query"

Postby Joel344 » Sun Sep 20, 2015 9:24 am

Never mind .....

This was already addressed.

The LUNCHTIME JOIN is still an option.

See y'all later.

Regards,

Joel
Joel344
 
Posts: 18
Joined: Sat Aug 22, 2015 4:59 am

Re: Help with "Securitylog Query"

Postby Justin Shafer » Tue Sep 22, 2015 6:07 am

Good work dude!
User avatar
Justin Shafer
 
Posts: 582
Joined: Sat Jul 28, 2007 7:34 pm
Location: Fort Worth, TX.


Return to Advanced Topics

Who is online

Users browsing this forum: No registered users and 5 guests