Hello, Maybe replace "ZONAGES_SHP_TAB2016".'identifiant' by "ZONAGES_SHP_TAB2016"."identifiant" or by "ZONAGES_SHP_TAB2016".identifiant ?
Regards, Brice 2016-08-31 15:21 GMT+02:00 Igor Korot <ikoro...@gmail.com>: > Hi, > > On Wed, Aug 31, 2016 at 9:14 AM, REGIANY Lucie <lregi...@regionpaca.fr> > wrote: > > > > HELLO > > I WOULD DO SELECT FROM MY TABLE > > select * > > FROM "_L93_ZONAGES_exportdirectory_list" > > WHERE "_L93_ZONAGES_exportdirectory_list".'TYPE' LIKE 'TAB%' > > OR > > "_L93_ZONAGES_exportdirectory_list".'TYPE' LIKE 'SHP%' > > > > AND AND SAVE THE RESULT IN A NEW TABLE ZONAGES__SHP_ TAB2016 > > > > > > I WOULD DO SELECT FROM MY TABLE > > > > select * > > FROM "ZONAGES_SHP_TAB2016" > > WHERE "ZONAGES_SHP_TAB2016".'identifiant' LIKE '%gare%' > > OR "ZONAGES_SHP_TAB2016".'identifiant' LIKE '%transport%' > > OR "ZONAGES_SHP_TAB2016".'identifiant' LIKE '%CFP%' > > OR "ZONAGES_SHP_TAB2016".'identifiant' LIKE '%tgv%' > > OR "ZONAGES_SHP_TAB2016".'identifiant' LIKE '%intermobilite%' > > OR "ZONAGES_SHP_TAB2016".'identifiant' LIKE '%velo%' > > OR "ZONAGES_SHP_TAB2016".'identifiant' LIKE '%ferre%' > > OR "ZONAGES_SHP_TAB2016".'identifiant' LIKE '%noeud%' > > OR "ZONAGES_SHP_TAB2016".'identifiant' LIKE '%aeroport%' > > OR "ZONAGES_SHP_TAB2016".'identifiant' LIKE '%velo%' > > OR "ZONAGES_SHP_TAB2016".'identifiant' LIKE '%flux%' > > OR "ZONAGES_SHP_TAB2016".'identifiant' LIKE '%deplacement%' > > OR "ZONAGES_SHP_TAB2016".'identifiant' LIKE '%route%' > > OR "ZONAGES_SHP_TAB2016".'identifiant' LIKE '%eurocopter%' > > OR "ZONAGES_SHP_TAB2016".'identifiant' LIKE '%bus%' > > OR "ZONAGES_SHP_TAB2016".'identifiant' LIKE '%Viarhonna%' > > OR "ZONAGES_SHP_TAB2016".'identifiant' LIKE '% aérien%' > > OR "ZONAGES_SHP_TAB2016".'identifiant' LIKE '%trajet%' > > OR "ZONAGES_SHP_TAB2016".'identifiant' LIKE '%ligne%' > > OR "ZONAGES_SHP_TAB2016".'identifiant' LIKE '%chemin%' > > OR "ZONAGES_SHP_TAB2016".'identifiant' LIKE '%voyageur%' > > OR "ZONAGES_SHP_TAB2016".'identifiant' LIKE '%mobilite%' > > OR "ZONAGES_SHP_TAB2016".'identifiant' LIKE '%interurbain%' > > OR "ZONAGES_SHP_TAB2016".'identifiant' LIKE '%navette%' > > ; > > > > I HAVE A ERROR > > why please? Help me it's possible > > What kind of error do you have? Can you post an error message? > Is first query returned any results? > > BTW, I would create a view based on the first select and then use > that view in the second query. Will simplify things a bit. > > Thank you. > > > > > AND > > > > AFTER THE SELECT > > I WOULD COUNT ON THE FILE FIELD DUPLICATES UP ALSO THE FIELD ID AND DATE > OF CHANGE > > > > TANK YOU > > > > > > _______________________________________________ > > sqlite-users mailing list > > sqlite-users@mailinglists.sqlite.org > > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users