Error Messages (A)

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z #

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:

  1. Download ODBCRegs.zip from http://support.crystaldecisions.com/updates.
  2. Replace the current C:\WINNT\SYSTEM32\P2SODBC.DLL file with the file contained in ODBCRegs.zip.
  3. Run OUTJOIN.REG from the zip file.
  4. Run regedt32 from a DOS prompt.
  5. Drill down to 


    HKEY_CURRENT_USER 
   >> SOFTWARE 
      >> SEAGATE SOFTWARE 
         >> CRYSTAL REPORTS 
            >> DATABASEOPTIONS 
               >> OUTERJOIN

  6. Double-click the 'PlusEqual' key.
  7. At the end of the string, add: 


    , olod4032

  8. Exit the registry editor and test.
Referenced by...