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)
> This should not contain any personal info but would allow me to look
> at the join issues involved,
>
> Best Wishes,
> Chris Travers
>
> ------------------------------------------------------------------------------
> EditLive Enterprise is the world's most technically advanced content
> authoring tool. Experience the power of Track Changes, Inline Image
> Editing and ensure content is compliant with Accessibility Checking.
> http://p.sf.net/sfu/ephox-dev2dev
> _______________________________________________
> Ledger-smb-devel mailing list
> Ledger-smb-devel@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
------------------------------------------------------------------------------
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
Ledger-smb-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
