SELECT acs.ownerid, sts.siteid, sts.sitename FROM Accounts acc INNER JOIN AccountSites acs ON (acc.AccountID = acs.AccountID) INNER JOIN Sites sts ON (acs.OwnerID = sts.OwnerID) WHERE acs.Accountid = <value>
------------------------------------------------------------------ Andrew Ewings Project Manager Thoughtbubble Ltd http://www.thoughtbubble.net ------------------------------------------------------------------ United Kingdom http://www.thoughtbubble.co.uk/ Tel: +44 (0) 20 7387 8890 ------------------------------------------------------------------ New Zealand http://www.thoughtbubble.co.nz/ Tel: +64 (0) 9 488 9131 ------------------------------------------------------------------ The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -----Original Message----- From: Aidan Whitehall [mailto:[EMAIL PROTECTED]] Sent: 26 November 2001 16:06 To: CF-Talk Subject: Composite primary key and INNER JOIN syntax Does anyone know the SQL to retrieve the OwnerID, SiteID and SiteName given a single AccountID value using the INNER JOIN syntax? (don't want to use = in the WHERE clause) Thanks if you can help! Accounts ==================== AccountID PK FullName AccountSites ==================== AccountID } OwnerID } Composite PK SiteID } Sites ==================== OwnerID } SiteID } Composite PK SiteName -- Aidan Whitehall <[EMAIL PROTECTED]> Macromedia ColdFusion Developer Fairbanks Environmental +44 (0)1695 51775 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
