RE: [Nolug] If you want to get out of town for a month...

> -----Original Message-----
> From: owner-nolug@joeykelly.net [mailto:owner-nolug@joeykelly.net]On
> Behalf Of E. Strade, B.D.
>
> SELECT candidate WHERE vote LIKE 'yes' AND vote LIKE 'no';
>
> ...is it sad that I think this is fun?
>
> Brett
>
No, what is sad, is that these 'jokes' are probably close to the queries
that they actually want.
Here is a quick poll query.

(I'm not sure if this syntax will actually work...depends on SQL DB)

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'

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