calculate variance



i have Query1 and Query2
Same columns in both (say c1, c2, c3, c4)

I want a Query3 with
Query3.c1 = Query1.c1 - Query2.c1
Query3.c2 = Query1.c2 - Query2.c2

where
Query1.c3 = Query2.c3 and
Query1.c4 = Query2.c4

this is the simplest way i can explain it
Please help me out on this by sending the answer to jojy.kk@xxxxxxxxx

Thnks
JOjy
.

Relevant Pages

  • Re: QuerySets in Dictionaries
    ... d= query1 ... d= query2 ... d= query3 ... Is there a way to do this that I'm missing? ...
    (comp.lang.python)
  • RadiobuttonList with headers
    ... I have a table with several horizontal radiobuttonlists like: ... Query1: O O O ... Query2: O O O ... Query3: O O O ...
    (microsoft.public.dotnet.framework.aspnet.webcontrols)
  • Re: field not equal
    ... If you want Query1 to return all the records from Query3 that do not have a ... match in Field1 of Query2, then you can do it one of several ways. ... SELECT Query3.* ...
    (microsoft.public.access.queries)
  • QuerySets in Dictionaries
    ... I need to create a dictionary of querysets. ... d= query1 ... d= query2 ... d= query3 ...
    (comp.lang.python)
  • Re: QuerySets in Dictionaries
    ... d= query1 ... d= query2 ... d= query3 ... Is there a way to do this that I'm missing? ...
    (comp.lang.python)