select ... having bug?

2001-03-20 Thread \Piotr Gapinski\
small problems with query below... my fault? mysql desc poll_answer; +-+-+--+-+-+---+ | Field | Type|Null | Key | Default | Extra | +-+-+--+-+-+---+ | poll_id | int(10) | | | 0 |

Re: select ... having bug?

2001-03-20 Thread Bill Marrs
At 09:47 AM 3/20/2001 +0100, \"Piotr Gapinski\" wrote: small problems with query below... my fault? mysql desc poll_answer; +-+-+--+-+-+---+ | Field | Type|Null | Key | Default | Extra | +-+-+--+-+-+---+

Re: select ... having bug?

2001-03-20 Thread Gerald L. Clark
Having works on the result table, not the source tables. Since you did not select cnt, having can not examine it. Maybe you ment 'where' instead of 'having' ? \"Piotr Gapinski\" wrote: small problems with query below... my fault? mysql desc poll_answer;