[thelist] mySQL Query Trouble

Ken Moore psm2713 at hotmail.com
Sat Nov 15 07:40:39 CST 2003


Hi all,

Beau Hartshorne wrote:

>I am trying to write a query that finds any individual timesheet records
>that have a work_date that falls outside of any pay_history record date
>range.

This type of query can be much easier than it looks. Often the solution is 
to write the query that selects everything that you do not want - then 
negate it. Most of the time, selecting data is much easier than unselecting 
it.

Ken

_________________________________________________________________
Concerned that messages may bounce because your Hotmail account is over 
limit? Get Hotmail Extra Storage! http://join.msn.com/?PAGE=features/es



More information about the thelist mailing list