Real fun: Not more than one table?

snorri · Post by **snorri** » Mon Dec 03, 2007 1:15 pm

Had a really funny error message after pasting (1:1!) a (working!) sql statement from Access to the Base sql query window and executing it:

The statement is invalid. It contains more than one table.

Well, life of a database is hard sometimes...
All the tables (2) exist and have exactly the same names like the Access tables.
Adding the Base typical double quotes to the query does not change anything.

Post by **DrewJensen** » Mon Dec 03, 2007 6:39 pm

Could you put a copy of the actual SQL statement up here to look at?

Real fun: Not more than one table?

Real fun: Not more than one table?

Re: Real fun: Not more than one table?