[AccessD] several query's in one!

pedro at plex.nl pedro at plex.nl
Thu Dec 2 15:02:23 CST 2004


Hello Group,

is it possible to make one sql query for the result below. Without using several query's to come to what is need. It would save me a lot of time.

i have

CoorX       CoorY        fieldA      fieldB     fieldC       fieldD      fieldE
206210     345120         5            1                        2          2
206733     345999         4                       2             1          3
207999     345170         1                       2             1
207452     345734         1            2                        2



i need 

CoorX       CoorY        total
206500     345500         20
207500     345500          9


Thanks  

Pedro  Janssen    




More information about the AccessD mailing list