Re: [Nolug] Verbose SQL

> Chris Reames wrote:
>
>> Select Democrats=(select count(voters) from tbl_state_list where vote
>> LIKE
>> 'yes', Republicans=(select count(voters) from tbl_state_list where vote
>> LIKE
>> 'no', Totals=(select count(voters) from tbl_state_list where vote is not
>> null) from tbl_state_list where st_code='Florida'
>
> Since you aren't the first to do this, I'll ask: why include "tbl" in
> the name of a database table? Should we put "col" or "fld" in the names
> of the columns of the table? Or "db" in the name of the database we
> connect to?
>
> It seems redundant: why do it?
>
>

I suspect the table name IS "tbl_state_list"
Therefore can not be found with "state_list"

Petri

___________________
Nolug mailing list
nolug@nolug.org
Received on 09/29/04