JokeCoat
|
Posted: 08/20/2003, 9:39 AM |
|
Hi,
Can anybody tell me what's wrong whit the following SQL:
FROM tblToernooi INNER JOIN (tblSpelers INNER JOIN (tblInschrijving INNER
JOIN tblTscore ON tblInschrijving.Inschrijving_id =
tblTscore.Inschrijving_id) ON tblSpelers.Speler_ID =
tblInschrijving.Speler_id) ON tblToernooi.Toernooi_id =
tblInschrijving.Toernooi_id
CCS says there's an error.
I have copied it from Access.
JokeCoat
|
|
|
DonB
|
Posted: 08/20/2003, 10:34 AM |
|
It's missing the SELECT part, might also need to include the semicolon at
the end of the string to get it to parse correctly. Is the CCS connection
defined as "Access" or as something else?
--
DonB
http://www.gotodon.com/ccbth
"JokeCoat" <ccs@jokecoat.nl> wrote in message
news:Xns93DDBDBE9BF11removethiscodecharge@66.180.229.147...
> Hi,
>
> Can anybody tell me what's wrong whit the following SQL:
>
> FROM tblToernooi INNER JOIN (tblSpelers INNER JOIN (tblInschrijving INNER
> JOIN tblTscore ON tblInschrijving.Inschrijving_id =
> tblTscore.Inschrijving_id) ON tblSpelers.Speler_ID =
> tblInschrijving.Speler_id) ON tblToernooi.Toernooi_id =
> tblInschrijving.Toernooi_id
>
> CCS says there's an error.
>
> I have copied it from Access.
>
> JokeCoat
|
|
|
JokeCoat
|
Posted: 08/20/2003, 10:48 AM |
|
Tnks Don,
But I forget to tell that there is a select part, but that's fine.
I think the problem is the INNER JOIN.
I connect to a MySQL connection. But I use MS Access as front end.
And this is the SQL used in Access, now I want to make the same query with
CCS. But I'm not familiar with SQL. I used CCS to make the query but than
too I get a JOIN problem.
JokeCoat
"DonB" <~ccbth~@gotodon.com> wrote in
news:bi0bfk$rt$1@news.codecharge.com:
> It's missing the SELECT part, might also need to include the semicolon
> at the end of the string to get it to parse correctly. Is the CCS
> connection defined as "Access" or as something else?
>
|
|
|
DonB
|
Posted: 08/20/2003, 12:31 PM |
|
What little I do know about MySQL is (at least I'm pretty sure) it demands
the semicolon at the end of the statement. I don't know that the Access
syntax for the joins is valid with MySQL - this is one thing that frequently
varies from SQL to SQL. You could try the alternate syntax:
e.g., SELECT <fieldlist> from table1, table2 WHERE table1.primarykey =
table2.primarykey
--
DonB
http://www.gotodon.com/ccbth
"JokeCoat" <ccs@jokecoat.nl> wrote in message
news:Xns93DDC9761310Dremovethiscodecharge@66.180.229.147...
> Tnks Don,
>
> But I forget to tell that there is a select part, but that's fine.
> I think the problem is the INNER JOIN.
> I connect to a MySQL connection. But I use MS Access as front end.
> And this is the SQL used in Access, now I want to make the same query with
> CCS. But I'm not familiar with SQL. I used CCS to make the query but than
> too I get a JOIN problem.
>
> JokeCoat
>
> "DonB" <~ccbth~@gotodon.com> wrote in
>news:bi0bfk$rt$1@news.codecharge.com:
>
> > It's missing the SELECT part, might also need to include the semicolon
> > at the end of the string to get it to parse correctly. Is the CCS
> > connection defined as "Access" or as something else?
> >
>
|
|
|
JokeCoat
|
Posted: 08/20/2003, 1:17 PM |
|
Tnx Don,
But the real problem was that I used In as column and that's not allowed.
JokeCoat
"DonB" <~ccbth~@gotodon.com> wrote in
news:bi0iak$a3f$1@news.codecharge.com:
> What little I do know about MySQL is (at least I'm pretty sure) it
> demands the semicolon at the end of the statement. I don't know that
> the Access syntax for the joins is valid with MySQL - this is one
> thing that frequently varies from SQL to SQL. You could try the
> alternate syntax:
>
> e.g., SELECT <fieldlist> from table1, table2 WHERE table1.primarykey
> = table2.primarykey
>
|
|
|
|