List:MySQL on Win32« Previous MessageNext Message »
From:jbonnett Date:August 4 2004 10:49pm
Subject:RE: SQL Query for newbie
View as plain text  
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
Thread
SQL Query for newbieKerry Frater3 Aug
RE: SQL Query for newbiejbonnett5 Aug
  • RE: SQL Query for newbieKerry Frater5 Aug