sqlite - SQL syntax error: no such column -
i new sql. stuck on error while, hope 1 me.
update roads1f set indoorpathway=pathway1f.indoor_pathway astext(roads1f.geometry)= astext(pathway1f.geometry)
the error
no such column pathway1f.indoor_pathway
i checked pathway1f
table, has indoor_pathway
column. did use wrong method reference data in table?
pathway1f , roads1f same. geometry can considered primary key. pathway1f has column indoor_pathway, roads1f doesn't have. want copy indoor_pathway pathway1f roads1f.
you need join
update roads1f set indoorpathway=( select pathway1f.indoor_pathway pathway1f astext(roads1f.geometry)= astext(pathway1f.geometry))
Comments
Post a Comment