RE: SQL Query for newbie

[Kerry Frater]

Thanks for that Jon, but it then compains about the INNER JOIN. I have
joined the ODBC list as well and have been told that MySQL doesn't support
the OUTER JOING syntax at all. There is  a mechanism  (fix) from Crystal
Reports to resolve the join syntax errors but I haven't been able to get the
fix to work yet.

Kerry

-----Original Message-----
From: jbonnett@stripped [mailto:jbonnett@stripped]
Sent: 04 August 2004 23:50
To: kerry@stripped; win32@stripped
Subject: RE: SQL Query for newbie


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