On Wed, Jun 22, 2011 at 10:12 AM, John Locke <[email protected]> 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 ------------------------------------------------------------------------------ Simplify data backup and recovery for your virtual environment with vRanger. Installation's a snap, and flexible recovery options mean your data is safe, secure and there when you need it. Data protection magic? Nope - It's vRanger. Get your free trial download today. http://p.sf.net/sfu/quest-sfdev2dev _______________________________________________ Ledger-smb-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
