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
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
2 matches
Mail list logo
