[LegacyUG] Help with complex SQL

2015-11-11 Thread Jay Wilpolt
I need to create a report of Tagged persons that includes; Marriage Date Groom Bride Groom Father Groom Mother Bride Father Bride Mother But I am at a loss on the way to do the joins so that I get the correct results. Here is my initial select SE

Re: [LegacyUG] Help with complex SQL

2015-11-12 Thread Sherry/Support
Please do no post graphics to the LUG list! Many of our listers still have slow connections or limited data rates. I don't know about anyone else, but the inline graphics can really mess up the formatting in my webmail as well. Please review the guidelines on our website at www.LegacyFamilyTree.

Re: [LegacyUG] Help with complex SQL

2015-11-12 Thread Stu and Priscilla Fanning
What are inline graphics? From: Sherry/Support To: legacyusergroup@LegacyUsers.com Sent: Thursday, November 12, 2015 9:41 AM Subject: Re: [LegacyUG] Help with complex SQL Please do no post graphics to the LUG list! Many of our listers still have slow connections or limited data rates

Re: [LegacyUG] Help with complex SQL

2015-11-12 Thread Sherry/Support
__ > From: Sherry/Support > To: legacyusergroup@LegacyUsers.com > Sent: Thursday, November 12, 2015 9:41 AM > Subject: Re: [LegacyUG] Help with complex SQL > > Please do no post graphics to the LUG list! > > Many of our listers still have slow connections or limited data rat

Re: [LegacyUG] Help with complex SQL

2015-11-12 Thread Colin Charman
Support > Legacy Family Tree > > > On Thu, Nov 12, 2015 at 7:12 AM, Stu and Priscilla Fanning > wrote: >> What are inline graphics? >> >> >> From: Sherry/Support >> To: legacyusergroup@LegacyUsers.com >> S

RE: [LegacyUG] Help with complex SQL

2015-11-12 Thread Brian L. Lightfoot
: Colin Charman [mailto:co...@charman.force9.co.uk] Sent: Thursday, November 12, 2015 10:51 AM To: legacyusergroup@LegacyUsers.com Subject: Re: [LegacyUG] Help with complex SQL Just trying to be helpful. The etiquette guidelines don't say anything about embedded images and I suspect I co

Re: [LegacyUG] Help with complex SQL

2015-11-13 Thread Colin Charman
e drought is over. Now lower the water rates back to > where they were. > > *From:*Colin Charman [mailto:co...@charman.force9.co.uk] > *Sent:* Thursday, November 12, 2015 10:51 AM > *To:* legacyusergroup@LegacyUsers.com > *Subject:* Re: [LegacyUG] Help with complex SQL > > Just tr

Re: [LegacyUG] Help with complex SQL

2015-11-13 Thread Jenny M Benson
On 13/11/2015 12:00, Colin Charman wrote: > (is "Jay" a boys name or girls name - we don't use it here in UK). What?! There have been tens of thousands of births registered in England and Wales where Jay is a forename. -- Jenny M Benson Legacy User Group guidelines: http://www.LegacyFamilyT

Re: [LegacyUG] Help with complex SQL

2015-11-13 Thread Colin Charman
Ok, you're right - I should have said "relatively uncommon". Ancestry tells me there have been 78,211 in 100 years with Jay as a first or middle name, so maybe I've met lots of them and didn't know it. Apologies to any Jays out there for thinking that your name wasn't used here - I now know that

RE: [LegacyUG] Help with complex SQL

2015-11-13 Thread Brian L. Lightfoot
http://www.babynameguide.com/categoryunisex.asp?strCat=Unisex From: Colin Charman [mailto:co...@charman.force9.co.uk] Sent: Friday, November 13, 2015 6:03 AM To: legacyusergroup@LegacyUsers.com Subject: Re: [LegacyUG] Help with complex SQL Ok, you're right - I should have

Re: [LegacyUG] Help with complex SQL

2015-11-13 Thread I Macaulay
: 76.0991 W Elv 137 M UTM     Don't Forget to Save the Stamps From: Brian L. Lightfoot To: legacyusergroup@LegacyUsers.com Sent: Friday, November 13, 2015 11:40 AM Subject: RE: [LegacyUG] Help with complex SQL Regards, http://www.babynameguide.com/categoryunisex.asp?strCat=U

Re: [LegacyUG] Help with complex SQL

2015-11-13 Thread Jay Wilpolt
And I am in the 90 % Thanks! Any Wilpolt's anywhere in the world are related to me. On Fri, Nov 13, 2015 at 6:02 AM, Colin Charman wrote: > Ok, you're right - I should have said "relatively uncommon". > > Ancestry tells me there have been 78,211 in 100 years with Jay as a first > or middle

Re: [LegacyUG] Help with complex SQL

2015-11-14 Thread Steve Hayes
; Ian Macaulay   Carp, Ontario > Open at 10:AM   Close at 5:00 PM > 45.2397 N long: 76.0991 W Elv 137 M UTM >     Don't Forget to Save the Stamps > > From: Brian L. Lightfoot > To: legacyusergroup@LegacyUsers.com > Sent: Friday, November 13, 2015 11:40 AM &