Re: Omit another where clause from original query
"Hal.sz S.ndor" <[email protected]> Wed, 20 Sep 2017 21:57:48 -0400
| Newsgroups | gmane.comp.db.mysql.general |
|---|---|
| Organization | the less, the better |
| Message-ID | <[email protected]> |
2017/09/19 17:19 ... Don Wieland: > Of these found rows, I want to omit those rows where there are rows found after the END TimeStamp based on ?below ?where clause: > > WHERE 1 AND apt.appt_status_id IN (16) AND apt.user_id IN (3) AND apt.time_start > ‘1504238399' > > We are trying to find Former Clients who have not been seen after the date range - Lapsed Client Report What are you getting that you want not to see? Certainly if you simply left off the upper half of the 'BETWEEN' you would get all those that you now get and all that have been left out by being dated over ‘1504238399'. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql