Advanced Search

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