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)
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)