On 06/22/2011 03:26 PM, Chris Travers wrote: > 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? >
Nope, I'm getting 7 rows. Haven't looked yet for an overloaded function... will do that when I get a chance and report back... Cheers, John Locke http://freelock.com ------------------------------------------------------------------------------ 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
