>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.
How about using 'not in' ala:
where fh1109.state not in ('TX', 'PA', 'ME')
Brad Eacker ([EMAIL PROTECTED])
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
