On 10/13/00, Lee Borkman penned: >Hi CV, > >Sure it supports them, but I seem to recall it has its own SQL syntax. Best >to use MSAccess' query builder, and then take a peek at the SQL that it >creates. It should give you the idea. I think SQL Server has some additional stuff you can use as shortcuts. Every outer join I've done in Access has also worked in SQL though. Here is a simple basic syntax: SELECT M.Main_Category_ID,M.Main_Category, C.Category_ID,C.Category FROM Main_Categories M LEFT OUTER JOIN Categories C ON M.Main_Category_ID = C.Main_Category_ID ORDER BY Main_Category,M.Main_Category_ID,Category And one a little more complex that joins 4 tables. SELECT Co.Country_ID,Country,Resume_ID FROM ((Countries Co LEFT OUTER JOIN Resumes R ON Co.Country_ID = R.Country_ID) LEFT OUTER JOIN categories CA on R.category_id = CA.category_id) LEFT OUTER JOIN Main_categories M on Ca.Main_category_id = M.Main_category_id WHERE R.Category_ID = CA.Category_ID and Ca.Main_Category_ID = M.Main_Category_ID and M.Main_Category_ID = #main# -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ 954.721.3452 ------------------------------------------------------------------------------ Archives: http://www.mail-archive.com/[email protected]/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
