Hi Bob/ All,
I cannot get the creation of the TEMPORARY Table to
work:
The select statement works fine:
mysql SELECT table1_id, Count(date) as c FROM Table2,
Table1
- WHERE Table2.date BETWEEN "2001-02-02" AND
"2001-02-06"
- AND Table2.table1_id=Table1.id
- GROUP BY Table1.id HAVING
explain what difference between dates
2001-02-04 and 2001-02-06 for
item2 and 2001-02-04 and 2001-02-06 for item1?
- Original Message -
From: Web Depressed [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Sunday, February 04, 2001 11:41 PM
Subject: Can anyone do this ?
Hi,
I've
Hi Bob,
Many thanks for that. I was hoping (through absolute
naiveity) not to have to go and calculate the number
of days with the specified range. Unless, of course
I could have mysql do this for me.
Can anyone tell me how I could generate such a list.
(ie something like:
SELECT BETWEEN
Hi,
Woh ! This is very strange. Any ideas ?
mysql SELECT * FROM Table2;
++-+---+
| date | no_of_items | table1_id |
++-+---+
| 2001-02-04 | 3 | 1 |
| 2001-02-05 | 2 | 1 |
| 2001-02-06 |
Hi,
I've been trying for a while now and I can't figure
out how to do the following:
In regular English, I wish to show all items for which
I have allocations greater than one for all days
encapsulated between the user input range.
User Input:
---
Date_from (ie. 2001-02-04)