Allow INNER JOIN in a simple two table join without the {oj} syntax as used by default by Crystal Reports XI Professional and Developer Editions. The following SQL statement from a Crystal Report example built using QuickBooks Employee and EmployeeEarning tables, now works correctly:-
SELECT "Employee"."Name", "Employee"."EmployeeAddressAddr1", "Employee"."EmployeeAddressAddr2", "Employee"."EmployeeAddressCity", "Employee"."EmployeeAddressCounty", "Employee"."EmployeeAddressPostalCode", "EmployeeEarning"."PayrollInfoPayPeriod", "EmployeeEarning"."PayrollInfoClassRefFullName", "EmployeeEarning"."PayrollInfoEarningsClearEarnings", "EmployeeEarning"."PayrollInfoEarningsPayrollItemWageRefFullName" FROM "Employee" "Employee" INNER JOIN "EmployeeEarning" "EmployeeEarning" ON "Employee"."Name"="EmployeeEarning"."Name" ORDER BY "Employee"."Name"
QODBC also supports Crystal Reports LEFT OUTER JOINs using the {oj} syntax like this:-
SELECT "Employee"."Name", "Employee"."EmployeeAddressAddr1", "Employee"."EmployeeAddressAddr2", "Employee"."EmployeeAddressCity", "Employee"."EmployeeAddressCounty", "Employee"."EmployeeAddressPostalCode", "EmployeeEarning"."PayrollInfoPayPeriod", "EmployeeEarning"."PayrollInfoClassRefFullName", "EmployeeEarning"."PayrollInfoEarningsClearEarnings", "EmployeeEarning"."PayrollInfoEarningsPayrollItemWageRefFullName" FROM {oj "Employee" "Employee" LEFT OUTER JOIN "EmployeeEarning" "EmployeeEarning" ON "Employee"."Name"="EmployeeEarning"."Name"} ORDER BY "Employee"."Name" |