I'm just getting into this and using support tools to build links etc. I
have Crystal Reports V9 and theur SQL designer support too.
I am using the tool to create the SQL call to extract fields from two tables
linked by an index column MatterRef
The FROM clause it produces is
{oj `LLCOPY`.`matters` matters INNER JOIN `LLCOPY`.`timerecords`
timerecords ON matters.`MatterRef` = timerecords.`MatterRef`}
and I get an error on the ODBC 3.51 call. I am able to edit the line e.g.
change oj to OUTER JOIN but it is complaining about the syntax "near" INNER
JOIN.
Can anyone advise please.
Regards
Kerry
