[snip]
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
[/snip]
Since I am not sure of your column definitions I do not know whether it
is fh1109.state or ssa1202.state or vapall.state....but for whichever
one you can add something like
AND fh1109.state NOT IN ('TX', 'PA', 'ME')
This is essentially a large OR statement
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
