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