Estrazione contatti per magazine


/ Published in: SQL
Save to your folder(s)

estrazione nominativi e indirizzi ultimi contatti per magazine


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.