RE: [mdb-dev] SELECT on multiple tables

[Fergus A. <f_W...@ya...>]

What you have described is standard SQL upto the point where you talk of
special characters.

Try delimiting the object names with square brackets which is the
standard for MS-ACCESS. =20

Try SELECT [table1].[column1] ...

This is not aggregated.  It is a 'complex' query in that more than one
table is used.  Aggregated would refer to a group by to  produce a
domain aggregate.

Regards

Fergus Allan


-----Original Message-----
From: mdb...@li...
[mailto:mdb...@li...] On Behalf Of Alexis
Gougerot
Sent: 08 June 2004 09:39
To: mdb...@li...
Subject: [mdb-dev] SELECT on multiple tables

Hi ,


I am not sure if it is really called "aggregated"...
With the actual CVS version it seems that we cannot do SQL statement
like for example :=20
"SELECT table1.column1, table2.column1 FROM table1,table2;"

My real statement is kinda longer but it is the same with WHERE
conditions too.
Everytime I tried to run the statement,there was a Syntax error from the
sql parser.
Im using perl DBD::ODBC with a JET4 mdb file full of underscores and
french typo like =E9 =E8 or =E7.=20

The question is simple, is it possible at the moment to do such queries
with the CVS version ???

Alexis




-------------------------------------------------------
This SF.Net email is sponsored by: GNOME Foundation
Hackers Unite!  GUADEC: The world's #1 Open Source Desktop Event.
GNOME Users and Developers European Conference, 28-30th June in Norway
http://2004/guadec.org
_______________________________________________
mdbtools-dev mailing list
mdb...@li...
https://lists.sourceforge.net/lists/listinfo/mdbtools-dev