Revision: 1896
Initial Code
Initial URL
Initial Description
Initial Title
Initial Tags
Initial Language
at November 20, 2006 01:30 by miziomon
Initial Code
SELECT TOP 1100 [cognome_info]+" "+[nome_info] AS ragio, "" AS ragio2, Replace("via " & [via_info],"via via","via") AS indirizzo, info.cap_info, info.citta_info, info.provincia_info FROM info GROUP BY [cognome_info]+" "+[nome_info], "", Replace("via " & [via_info],"via via","via"), info.cap_info, info.citta_info, info.provincia_info HAVING (((Replace("via " & [via_info],"via via","via")) Is Not Null) AND ((info.cap_info) Is Not Null)) ORDER BY Max(info.data_info) DESC;
Initial URL
Initial Description
estrazione nominativi e indirizzi ultimi contatti per magazine
Initial Title
Estrazione contatti per magazine
Initial Tags
Initial Language
SQL