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'
;


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=arch...@jab.org