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 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]
