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 fh1109.state NOT IN ('TX','PA','ME')"
/Johan
[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]