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

[Arthur Fuller]

Won't a simple LIMIT 1 do what you want? Or am I missing something?

Arthur

On Fri, Mar 13, 2009 at 3:24 PM, Nigel Peck <nigel.peck@stripped>wrote:

> Nigel Peck wrote:
>
>> 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'
>> ;
>>
>>
>>
>>