KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I have a MySQL query that joins two tables Voters Households They join on voters.household_id and household.id . Now what I need to do is to modify it where the voter table is joined to a third table called elimination, along voter.id and elimination.voter_id . However the catch is that I want to exclude any records in the voter table that have a corresponding record in the elimination table. How do I craft a query to do this? This is my current query: SELECT `voter`.`ID`, `voter`.`Last_Name`, `voter`.`First_Name`, `voter`.`Middle_Name`, `voter`.`Age`, `voter`.`Sex`, `voter`.`Party`, `voter`.`Demo`, `voter`.`PV`, `household`.`Address`, `household`.`City`, `household`.`Zip` FROM (`voter`) JOIN `household` ON `voter`.`House_ID`=`household`.`id` WHERE `CT` = '5' AND `Precnum` = 'CTY3' AND `Last_Name` LIKE '%Cumbee%' AND `First_Name` LIKE '%John%' ORDER BY `Last_Name` ASC LIMIT 30
Tags (comma-separated)
Save Edits
Cancel