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 HAVI
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 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 "20
; wrote:
> Can you 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, Februa
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)
Date_to
