Using a view in mySQL, From the current query: SELECT blah, blah... from (`idc`.`locations` join `idc`.`personnel` on((`idc`.`personnel`.`county_id` = `idc`.`locations`.`locID`)))
`idc`.`personnel`.`county_id` is a LIST So I need to add a WHERE statement to the above like: WHERE `idc`.`locations`.`locID` IN `idc`.`personnel`.`county_id` for the life of me I can't get the syntax for the WHERE to work correctly. Maybe I'm trying to put it in the wrong place ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236329 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54