Re: alias problem and odd warnings

2010-06-15 Thread Joerg Bruehe
Hi Brian, all! brian wrote: > On 10-06-14 09:13 PM, brian wrote: >> [[...]] >> >> This not only gives an empty set, but also throws 171 warnings (more on >> that below). I've remove both the WHERE and GROUP BY clauses with no >> success. I've been staring at this for an hour now and can't see wha

Re: alias problem and odd warnings

2010-06-14 Thread brian
On 10-06-14 09:13 PM, brian wrote: Using 5.1.41/Ubuntu I have 2 tables, members & countries. The former has a column, country_id (tinyint(3) unsigned). The countries id column is the same (although auto_increment). I'm trying to select just those countries for which there is a member. So I decid

alias problem and odd warnings

2010-06-14 Thread brian
Using 5.1.41/Ubuntu I have 2 tables, members & countries. The former has a column, country_id (tinyint(3) unsigned). The countries id column is the same (although auto_increment). I'm trying to select just those countries for which there is a member. So I decided this query should do the trick