On Wed, 2006-05-24 at 11:20 -0400, Igor Tandetnik wrote:
> David Bicking wrote:
> > This is more an SQL than SQLITE question.
> >
> Something like this:
>
> update requests r set psref =
> (select psref from actuals a where r.cust=a.cust and
> r.amount=a.amount)
> where r.psref is null and
David Bicking wrote:
This is more an SQL than SQLITE question.
I have two tables: (The relevant fields are)
CREATE TABLE REQUESTS (
REQ_ID INTEGER PRIMARY KEY,
CUST TEXT,
AMOUNT FLOAT,
PSREF TEXT)
CREATE TABLE ACTUALS (
PSREF TEXT,
CUST TEXT,
AMOUNT FLOAT )
SELECT * FROM REQUESTS;
1 | 100
2 matches
Mail list logo