Posted By

miziomon on 11/20/06


Tagged

access


Versions (?)

Estrazione contatti per magazine


 / Published in: SQL
 

estrazione nominativi e indirizzi ultimi contatti per magazine

  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  

You need to login to post a comment.