Re: [sqlite] SQLite and "crosstab queries"

Hi Steve! - ( oh, and also Brona who replied to my query ) - I found quite a good definition of a crosstab query on part of Microsoft's website - "Crosstab query" - A query that caclulates a sum, average count or other type of total on records, and then groups the result by two types o

Re: [sqlite] SQLite and "crosstab queries"

Andy Elvey wrote: Hi everyone - I'm a "first-timer" here, and was wondering - does SQLite support crosstab queries? Many thanks in advance - bye for now! - Andy If you mean something like: select a.*, b.* from a,b where a.column=1 or b.another=5; or select a.*, b.* from a left join b on (a.i

[sqlite] SQLite and "crosstab queries"

Hi everyone - I'm a "first-timer" here, and was wondering - does SQLite support crosstab queries? Many thanks in advance - bye for now! - Andy