I think I would just leave the oj out altogether.
{`LLCOPY`.`matters` matters INNER JOIN `LLCOPY`.`timerecords` timerecords ON
matters.`MatterRef` = timerecords.`MatterRef`}
Then it looks like a valid FROM clause.
John Bonnett
-----Original Message-----
From: Kerry Frater [mailto:kerry@stripped]
Sent: Tuesday, 3 August 2004 10:44 PM
To: Win32@Lists. Mysql. Com
Subject: SQL Query for newbie
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
