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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists