Date: Sat, 27 Sep 2014 17:55:24 -0700
To: <lojban@lojban.org>
From: Crisis Survival Strategy
 <Maggie.Lucas@wadmus.com>
Message-ID: <20140927184832.19279.97822.Lucas@northernbreezetrading.wadmus.com>
Subject: In the event of a riot
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
MIME-Version: 1.0
X-Spam_score: -2.5
X-Spam_score_int: -24
X-Spam_bar: --

- Current Status of the Nation -
Prepared for: General Civilian Population


As recent events unfold in our nation it is our duty to inform and prepare you for the coming apocalypse of Biblical proportions.

http://www.wadmus.com/US/survival/update/september.html


Ending up in a FEMA camp is the last place you want to be.
And to many of you I know thats just words, so let me break it down for you:

Do You Know What Its Like To Watch Your Children Beg For Water?

Do you know what its like to have angry rioters ransack your personal home, your kids bedroom?

To have grown men doing as they wish with your family, your children, your grandchildren, while you are forced to sit and watch and do nothing?

Could you live with yourself?
http://www.wadmus.com/US/survival/update/september.html


Commission for National Well-Being


USI Group  - EML status
one-nine-four-eight Abbey Danville, IN 46122


Please understand that I have very limited experience with SQL. I realise that even what I got so far can be heavily optimised (with joins etc) and may not even be correct.
------
The reason I got stuck is that the solution I had in mind would work if I could use some kind of loop, and I only just realised that this is not something you easily do in an SQL query of this kind.

create view groups as 
select   a.Client_id
       , c.Registration_id
from AssociatedClient as a 
join AssociatedClient as b on a.Registration_id = b.Registration_id 
join AssociatedClient as c on b.Client_id = c.Client_id;