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.
[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.
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,
Hi,
I guess you juat should add on a AND fh1109.state NOT IN
('TX','PA','ME')
Also I think your AND conditions are a bit overdetermining, you can
probably do just :
WHERE fh1109.state = ssa1202.state and
fh1109.cd = ssa1202.cd and
fh1109.state = vapall.state and
fh1109.cd = vapall.cd and
AND
With conditions in the WHERE clause. Add something like
AND fh1109.state NOT IN ('TX', 'PA', 'ME')
to yours.
Michael
[EMAIL PROTECTED] wrote:
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
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.