On Tuesday 28 March 2006 17:15, Les Mizzell wrote: > `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`
`idc`.`locations`.`locID` IN (`idc`.`personnel`.`county_id`) ? TBH 'in' is very expensive, maybe `idc`.`locations`.`locID` = `idc`.`personnel`.`county_id` would be better :-) -- Tom Chiverton Advanced ColdFusion Programmer ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236331 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
