Re: [ADMIN] overcoming a recursive relationship in a sql statement

2012-02-04 Thread Kevin Grittner
wrote: > I have a list of organizations in table:organization and a one to > many list of organizational partnerships in a second table > (table:partners). The 'partners' table lists each organization id > that belongs to each partnership. > > The partnership relationships are recursive in that

Re: [ADMIN] overcoming a recursive relationship in a sql statement

2012-02-01 Thread Steve Crawford
On 02/01/2012 03:27 PM, brooks.gl...@comcast.net wrote: Hello, ... I'm not sure I fully understand the problem and may, therefore, oversimplify but I'll take a stab. It sounds like you have organizations and organizations can form partnerships with one another. My initial approach would be

Re: [ADMIN] overcoming a recursive relationship in a sql statement

2012-02-01 Thread Craig James
On Wed, Feb 1, 2012 at 3:27 PM, wrote: > Hello, > > So I am not very advanced in SQL, and after a week of wild SQL > experimenting have finally reduced my thought process to a complete blank > on this query... > > I have a list of organizations in table:organization and a one to many > list of o

[ADMIN] overcoming a recursive relationship in a sql statement

2012-02-01 Thread brooks . glenn
Hello, So I am not very advanced in SQL, and after a week of wild SQL experimenting have finally reduced my thought process to a complete blank on this query... I have a list of organizations in table:organization and a one to many list of organizational partnerships in a second table (tabl