tax_and_reg_join.sql

SELECT 
	`dutchess_tax_roll`.`parcel_location_address`,
	`dutchess_tax_roll`.`primary_owner`,
	`dutchess_tax_roll`.`street_address`,
	`dutchess_tax_roll`.`loc_st_name`,
	`dutchess_tax_roll`.`city_state_zip_code`
FROM `state_boe_active_012219`
RIGHT JOIN `dutchess_tax_roll` ON (
	`dutchess_tax_roll`.`parcel_location_address` = `state_boe_active_012219`.`CUSTOM_STREET_ADDRESS`
)
WHERE 
	(`state_boe_active_012219`.`COUNTYVRNUMBER` IS NULL) &&
	(`dutchess_tax_roll`.`prop_class` >= 200) && (`dutchess_tax_roll`.`prop_class` < 300) &&
	(`dutchess_tax_roll`.`primary_owner` NOT LIKE CONCAT('%LLC%')) &&
	(`dutchess_tax_roll`.`primary_owner` NOT LIKE CONCAT('%Bank Trust%')) &&
	(`dutchess_tax_roll`.`primary_owner` NOT LIKE CONCAT('%City of%')) &&
	(`dutchess_tax_roll`.`primary_owner` NOT LIKE CONCAT('%N Y S%')) &&
	(`dutchess_tax_roll`.`primary_owner` NOT LIKE CONCAT('%Ltd%')) &&
	(`dutchess_tax_roll`.`primary_owner` NOT LIKE CONCAT('%Assn%'))