[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Employee search question for 1.3



On Wed, Jun 22, 2011 at 10:12 AM, John Locke <..hidden..> wrote:
> On 06/21/2011 04:02 PM, Chris Travers wrote:
>> Hi John;
>>
>> In terms of the duplication issue can you:
>>
>> SELECT p.id as person_id, e.id as entity_id
>>   FROM person p
>>   JOIN   entity e ON (e.id = p.entity_id)
>>  order by p.id;
>>
>
> db=> SELECT p.id as person_id, e.id as entity_id
> db->   FROM person p
> db->   JOIN   entity e ON (e.id = p.entity_id)
> db->  order by p.id;
>  person_id | entity_id
> -----------+-----------
>         1 |         1
>         3 |       653
>         4 |       654
>         5 |       667
> (4 rows)
>
And are you only seeing four rows total in the report?

Best Wishes,
Chris Travers