[sqlite] Problem with inner join and update statement

[Christoph Gassmann | aquantum GmbH]

Dear List,

I´m new to sqlite und have a problem with an update-SQL.

I have a log-Table of a webpage-logger and for faster selects i need the seconds 
between to clicks.

I found out a select-statement that produces the seconds. Here it is:

SELECT round(julianday(t2.dTimestamp)*86400 - julianday(t1.dTimestamp)*86400) as 
secondsFromLast FROM tProject1Logs t1 INNER JOIN tProject1Logs t2 WHERE t1.sSession = 
t2.sSession AND t1.nfClicks = (t2.nfClicks - 1) 

Now I want to update my Table with this results. I have to write it in 
"t1.secondsFromLast". How can I do this?

I got a syntax-error if I do put a FROM in the update-statement. With other databases 
I can do this...

Tanks for help.

Regards 

---
Christoph Gassmann
aquantum GmbH

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]