Try: Select company_ID, company_name, contact_company_FK, contact_name >From companies, Contacts Where company_ID(+) = contact_company_FK
On Mon, 20 Dec 2004 12:37:24 -0500, Ray Champagne <[EMAIL PROTECTED]> wrote: > Yea, that is what I did, but keep getting an error saying "Join not supported" > > Here is a copy of the error message I get: > > Error Executing Database Query. > > [Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft > Access Driver] Join expression not supported. > > The error occurred in D:\CFusionMX\wwwroot\Data\CV_ADMIN\pages\view.cfm: > line 13 > > Maybe this is specific to Access? > > Ray > > At 12:35 PM 12/20/2004, you wrote: > >Select company_ID, company_name, contact_company_FK, contact_name > > From companies LEFT OUTER JOIN > >Contacts ON company_ID = contact_company_FK > > > >Or RIGHT > > > >-e > > > >-----Original Message----- > >From: Ray Champagne [mailto:[EMAIL PROTECTED] > >Sent: Monday, December 20, 2004 12:23 PM > >To: CF-Talk > >Subject: database query > > > >I have two tables in my DB: > > > >Companies: > > > >company_ID (PK) > >company_name > >etc > > > >Contacts: > > > >contact_company_FK (FK linked to company_ID) > >contact_name > >etc > > > >What I need to do is query the DB and get all the companies and all the > >contacts associated with that company, even if there are no contacts for a > >particular company. I am passing in the #company_ID# to the page. I think > >what I am supposed to be doing is a LEFT JOIN, but I can't get the syntax > >to work correctly. > > > >Anybody got any ideas for this? I am using the evil MS Access DB and CFMX > >6.1. > > > >Thanks! > > > >Ray > > > > > > > >============================================= > >Ray Champagne - Senior Application Developer > >CrystalVision Web Site Design and Internet Services > >603.433.9559 > >www.crystalvision.org > >============================================= > > > >The information contained in this transmission (including any attached > >files) is CONFIDENTIAL and is intended only for the person(s) named > >above. If you received this transmission in error, please delete it > >from your system and notify us immediately. If you are not an intended > >recipient, please note that any use or dissemination of the information > >contained in this transmission (including any attached files) and the > >copying, printing, or retransmission of that information is strictly > >prohibited. You can notify us by return email or by phone at 603.433.9559. > >Thank you. > > > > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188290 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
