Re: [sqlite] Performance Problems with joining and subqueries

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Da Martian wrote: > Regarding using "Case" I didnt know sqlite supported this. In fact looking > at core functions on the web there isnt any mention of a case statement, nor > in aggregate functions. Case is not a function but rather an expression. Y

Re: [sqlite] Performance Problems with joining and subqueries

Hi I do appologise. In my hast, I did copy bits of a larger query. The queries are correct they just have extra bits around the edges. I will post the corrections below. Regarding using "Case" I didnt know sqlite supported this. In fact looking at core functions on the web there isnt any mention

Re: [sqlite] Performance Problems with joining and subqueries

Da Martian <[EMAIL PROTECTED]> wrote: > I have two tables as follows: > > CREATE TABLE ROT_DIM_CONTRACT_LINE (ContractNo Integer,ContractLine > Integer,StartDate Integer,EndDate Integer,NCRAmt Float,Item > Integer,BusinessArea Text,ProductGroup Text,ProductStyle Text,Site > Text,Customer Integer,Pr

Re: [sqlite] Performance Problems with joining and subqueries

I have two tables as follows: CREATE TABLE ROT_DIM_CONTRACT_LINE (ContractNo Integer,ContractLine Integer,StartDate Integer,EndDate Integer,NCRAmt Float,Item Integer,BusinessArea Text,ProductGroup Text,ProductStyle Text,Site Text,Customer Integer,PrincipalContractNo Text,SASContract Text,ContractM

Re: [sqlite] Performance Problems with joining and subqueries

"Da Martian" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Does anyone have any ideas on how to optimise this type of process in > SQLite? What type of process? Show your tables and your query. Igor Tandetnik ___ sqlite-users mailing