From: Roy Harvey <RoyHarv@compuserve.com>
Subject: Re: SQL query peeps help me!!!!
Date: Thu, 08 Aug 2002 08:44:41 -0400
Organization: //http://go.compuserve.com/internetmail
Reply-To: 76300.2521@compuserve.com
Message-ID: <4rp4lucfsqdhogdcmf2v8q7t2m21aq4qgi@4ax.com>
References: <8e8664e8.0208080334.1851bae1@posting.google.com>
X-Newsreader: Forte Agent 1.92/32.572
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: comp.databases.oracle.server,microsoft.public.sqlserver.server,comp.databases.ms-sqlserver
NNTP-Posting-Host: 216.192.80.28
Path: news.easynews.com!easynews!crtntx1-snh1.gtei.net!nycmny1-snh1.gtei.net!news.gtei.net!newsfeed.mathworks.com!kibo.news.demon.net!demon!newsfeed00.sul.t-online.de!t-online.de!tkmsftngp01!tkmsftngp08
Lines: 1         
Xref: easynews comp.databases.oracle.server:157263 microsoft.public.sqlserver.server:192682 comp.databases.ms-sqlserver:76356
X-Received-Date: Thu, 08 Aug 2002 05:45:25 MST (news.easynews.com)

Neil,

>I want the contact info returned but only the first address found for
>each contact.....

This will look best if viewed with a fixed pitch font.

SELECT C.ContactID, C.FileAs, C.Title,
       C.FirstName, C.LastName, C.MainContact,
       A.Address1, A.Address2,
       A.Address3, A.Address4,
       A.Address5, A.Town, A.County,
       A.Postcode, A.Country,
       I.InstituteName, L.MainAddress
  FROM tblContacts as C
  JOIN tblContLinkAddress as L
    ON C.ContactID = L.ContactID
  JOIN tblContAddress as A
    ON L.AddressID = A.AddressID
  LEFT JOIN tblInstitutes as I
    ON C.InstituteID = I.InstituteID)
  LEFT JOIN tblInstituteTypes as T
    ON I.InstituteTypeID = T.InstituteTypeID)
 WHERE A.AddressID = (select min(AddressID)
                        from tblContLinkAddress as L2
                       where C.ContactID = L2.ContactID)

Roy