[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