Very simple SQL question

amator

Registered User.
Local time
Tomorrow, 01:13
Joined
Aug 1, 2006
Messages
23
Hi
This shouldn't be hard SQL-statement but I just doesen't got it how it should be done.
I have a two queries which lists same things. One of my query1 look like this:
[start time] [end time] [duration time][fault]
xxx.............xxx...........xxx................xxx
Now I Count different faults happened together and Sum duration times together something like this:
SELECT query1.[fault], Count(query1.fault), Sum(query1.[duration time])
FROM query1;
But how I can do this query from two queries? (My query2 looks like same)
 
Are you familar with a Union query? This is where you can take the results of two queries and put it into one recordset. The queries must have the same number of columns.
 

Users who are viewing this thread

Back
Top Bottom