%META:TOPICPARENT{name="ErrorMessagesA"}% ==Error Messages (A)== [[ErrorMessagesA|A]] [[ErrorMessagesB|B]] [[ErrorMessagesC|C]] [[ErrorMessagesD|D]] [[ErrorMessagesE|E]] [[ErrorMessagesF|F]] [[ErrorMessagesG|G]] [[ErrorMessagesH|H]] [[ErrorMessagesI|I]] [[ErrorMessagesJ|J]] [[ErrorMessagesK|K]] [[ErrorMessagesL|L]] [[ErrorMessagesM|M]] [[ErrorMessagesN|N]] [[ErrorMessagesO|O]] [[ErrorMessagesP|P]] [[ErrorMessagesQ|Q]] [[ErrorMessagesR|R]] [[ErrorMessagesS|S]] [[ErrorMessagesT|T]] [[ErrorMessagesU|U]] [[ErrorMessagesV|V]] [[ErrorMessagesW|W]] [[ErrorMessagesX|X]] [[ErrorMessagesY|Y]] [[ErrorMessagesZ|Z]] [[ErrorMessagesSymbols|#]] ===An explicit JOIN must be the only element in a FROM clause (2841)=== Only one {{{JOIN}}} may occur in the {{{FROM}}} clause of a Progress {{{SELECT}}} statement. If you include additional {{{JOINs}}} or tables in your {{{FROM}}} clause, you will receive "An explicit JOIN must be the only element in a FROM clause (2841)" errors. You must remove these extra {{{JOINs}}} or tables to continue. If this problem is associated with Crystal Reports and an OpenLink Release 4.x upgrade, take the following action: # Download {{{ODBCRegs.zip}}} from [[http://support.crystaldecisions.com/updates]]. # Replace the current {{{C:\WINNT\SYSTEM32\P2SODBC.DLL}}} file with the file contained in {{{ODBCRegs.zip}}}. # Run {{{OUTJOIN.REG}}} from the zip file. # Run {{{regedt32}}} from a DOS prompt. # Drill down to {{{ HKEY_CURRENT_USER >> SOFTWARE >> SEAGATE SOFTWARE >> CRYSTAL REPORTS >> DATABASEOPTIONS >> OUTERJOIN }}} # Double-click the 'PlusEqual' key. # At the end of the string, add: {{{ , olod4032 }}} # Exit the registry editor and test.