I'm stuck with what should be a simple problem, but I can't move past it.
Two tables, I'm trying to update one tables latitude with the other
tables latitude where the zipcode match. (See below)
Can anybody help me? Thanks in advance.
sqlite> .schema
CREATE TABLE agents("ZIP" text ,"CUSTOMER" text ,"PHONE" text ,"CITY"
text ,"WEB
SITE" text ,"EMAIL"
, latitude double default 0, logitude double default 0);
CREATE TABLE zip(ZipCode text ,PrimaryRecord text ,Population text
,HouseholdsPe
rZipCode text ,WhitePopulation text ,BlackPopulation text
,HispanicPopulation te
xt ,AsianPopulation text ,HawaiianPopulation text ,IndianPopulation text
,OtherP
opulation text ,MalePopulation text ,FemalePopulation text
,PersonsPerHousehold
text ,AverageHouseValue text ,IncomePerHousehold text ,Latitude text
,Longitude
text ,Elevation text ,State text ,StateFullName text ,CityType text
,CityAliasAb
breviation text ,AreaCode text ,City text ,CityAliasName text ,County
text ,Coun
tyFIPS text ,StateFIPS text ,TimeZone text ,DayLightSaving text ,MSA
text ,PMSA
text ,CSA text ,CBSA text ,CBSA_Div text ,CBSAType text ,CBSAName text
,MSAName
text ,PMSAName text ,Region text ,Division text ,MailingName text
,PreferredLast
LineKey text ,ClassificationCode text ,MultiCounty text ,CSAName text
,CBSA_Div_
Name text ,CityStateKey text ,CityAliasCode text ,CityMixedCase text
,CityAliasM
ixedCase text ,StateANSI text ,CountyANSI text ,FacilityCode text
,CityDeliveryI
ndicator text ,CarrierRouteRateSortation text ,FinanceNumber text
,UniqueZIPName
);
CREATE INDEX "agentsZIP" on agents("ZIP");
CREATE INDEX zipZipCode on zip(ZipCode);
sqlite> update agents set latitude=Latitude where agents.latitude=0 and
agents.Z
IP=zip.ZipCode;
Error: no such column: zip.ZipCode
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
