Everyone,
Thanks for the help. I'm not sure why because I swear on everything
holy that I didn't change anything, but the query now works as desired.
Rather than using BETWEEN, I'm just using >= and <=. Perhaps I was
missing a quote or something in my old query that was causing it to
return t
You still did not send your table definitions.
Jeremy Brown [InfoSend] wrote:
Michael,
Thanks for the response. My query was kind of long, so I was just
trying to simplify. Should have included it anyways.
Here is my query:
select REFCLIENTS.sample, TRACKING.* from REFCLIENTS, TRACKING where
T
Michael,
Thanks for the response. My query was kind of long, so I was just
trying to simplify. Should have included it anyways.
Here is my query:
select REFCLIENTS.sample, TRACKING.* from REFCLIENTS, TRACKING where
TRACKING.ccode LIKE 'ABC' AND REFCLIENTS.code = TRACKING.ccode AND
TRACKING.jo
Jeremy Brown [InfoSend] wrote:
Hello,
I currently have a table with a "completed" DATETIME field. I am trying
to run a query that will return all rows *inclusive* of the start and
end dates. I have tried the following query:
SELECT `name`, `completed` FROM `table` WHERE `completed` BETWEEN
'
Hello,
I currently have a table with a "completed" DATETIME field. I am
trying to run a query that will return all rows *inclusive* of the
start and end dates. I have tried the following query:
SELECT `name`, `completed` FROM `table` WHERE `completed` BETWEEN
'2004-07-21' AND '2004-07-23';
