Advanced Search

Estrazione contatti per magazine

/ Published in: SQL
Save to your folder(s)
estrazione nominativi e indirizzi ultimi contatti per magazine

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  1. SELECT TOP 1100 
  2.  
  3. [cognome_info]+" "+[nome_info] AS ragio, 
  4. "" AS ragio2, REPLACE("via " & [via_info],"via via","via") AS indirizzo, 
  5. info.cap_info, 
  6. info.citta_info, 
  7. info.provincia_info
  8.  
  9. FROM info
  10.  
  11. GROUP BY [cognome_info]+" "+[nome_info], "", 
  12. REPLACE("via " & [via_info],"via via","via"), 
  13. info.cap_info, 
  14. info.citta_info, 
  15. info.provincia_info
  16.  
  17. HAVING (((REPLACE("via " & [via_info],"via via","via")) IS NOT NULL) 
  18. AND ((info.cap_info) IS NOT NULL))
  19.  
  20. ORDER BY MAX(info.data_info) DESC;

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.