Something like:
select
fh1109.state,
fh1109.cd,
fh1109.party,
fh1109.representative,
ssa1202.total,
((total-children*percentunder18)/vapall)*100,
ssa1202.retired_workers,
ssa1202.disabled_workers,
ssa1202.widow,
ssa1202.wives_and_husbands,
ssa1202.children
from ssa1202, fh1109, vapall
where
fh1109.state = ssa1202.state and
fh1109.cd = ssa1202.cd and
fh1109.state = vapall.state and
fh1109.cd = vapall.cd and
ssa1202.state = vapall.state and
ssa1202.cd = vapall.cd
AND ssa1202.state NOT IN('TX','PA','ME')
Terry
----- Original Message -----
> How do I exclude some rows in a table? I am merging columns from three
> tables all of which show all congressional districts in all states. I
> want to exclude those congressional districts in TX, PA and ME. My
> coding that brings up data for all congressional districts is shown
> below. Thanks.
>
> Ken
>
> ******
> select
> fh1109.state,
> fh1109.cd,
> fh1109.party,
> fh1109.representative,
> ssa1202.total,
> ((total-children*percentunder18)/vapall)*100,
> ssa1202.retired_workers,
> ssa1202.disabled_workers,
> ssa1202.widow,
> ssa1202.wives_and_husbands,
> ssa1202.children
> from ssa1202, fh1109, vapall
>
> where
> fh1109.state = ssa1202.state and
> fh1109.cd = ssa1202.cd and
> fh1109.state = vapall.state and
> fh1109.cd = vapall.cd and
> ssa1202.state = vapall.state and
> ssa1202.cd = vapall.cd
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
