Return to Snippet

Revision: 1896
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