Re: Getting single results per (left) record with INNER JOIN

[Nigel Peck]

Nigel Peck wrote:
> ...
> My query is:
> 
> SELECT
>     `People`.`person_id`,
>     `People`.`name`,
> FROM
>     `People`
> INNER JOIN
>     `Person_postal_addresses`
> ON
>     `Person_postal_addresses`.`person_id` = `People`.`person_id`
> WHERE
>     `People`.`name` REGEXP 'example'
>     OR
>     `Person_postal_addresses`.`address` REGEXP 'example'
> ;

Sorry, there was a typo in my query, should have been:

SELECT
     `People`.`person_id`,
     `People`.`name`
FROM
     `People`
INNER JOIN
     `Person_postal_addresses`
ON
     `Person_postal_addresses`.`person_id` = `People`.`person_id`
WHERE
     `People`.`name` REGEXP 'example'
     OR
     `Person_postal_addresses`.`address` REGEXP 'example'
;