Here's a way to go with pure SQL;
create table cars (recid,qty,make,model,year,engine,color,state,price);
create table states (abbr,name);
insert into states values("ca","California");
insert into cars values(1,5,"Ford","Bandit",2005,2000,"Red","ca",5000);
select make,(select name from states where abbr=state) as statename from
cars;
Steve
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
rg] On Behalf Of Richard Nagle
Sent: 26 September 2005 04:14
To: sqlite-users@sqlite.org
Subject: [sqlite] Data Manipulation ?
Does SQLite support any direct built-in commands, that can
manipulate data?
ie.
suppose the boss wanted a report of cars honda in CA,
but he wants to see the California instead of CA,
so you need to convert all the state fields into full names,
how would this be done...
Fields are as follows:
recid
qty
make
model
year
engine
color
state
price
Thanks -
Richard
--
I will not be pushed, filed, stamped, indexed, briefed, debriefed, or
numbered!
My life is my own - No. 6
