Hi,
I'm using base pointing to MS 2003 excel as the data source. I have a worksheet that was converted to a table in base, called results and it has following columns:
id, path, others
I'm trying to run a base query like this:
select * from results where path in ('a','b');
I'm getting an error that seems to indicate that the "Statement to complex"
I need to use the "IN" clause and not any other types of join, at least that's what I'm thinking. Can anyone help?
Thanks,
Mike
Select statement with IN clause
Re: select statement with IN clause
I'm certainly not a SQL expert but what about a simple WHERE?
select * from results where path = ('a' OR'b');
Syntax likely wrong, but you get the idea.
select * from results where path = ('a' OR'b');
Syntax likely wrong, but you get the idea.
Ron from Iowa, USA
Re: select statement with IN clause
I think that this is a limitation of the execution engine for spreadsheets. I tried the same and got the same error message. I remember a similar limitation for the MS Jet Engine accessing spreadsheets and text files. Its has limited access modes for querying against spreadsheets. As RonIA says select * from results where path = 'a' or path = 'b' (I've corrected the syntax) works fine.
Ubuntu 11.04-x64 + LibreOffice 3 and MS free except the boss's Notebook which runs XP + OOo 3.3.