How To join 2 Queries??

[zaq888]

This is the first one..

SELECT TUnit.[cs-username]
FROM TUnit LEFT JOIN [SELECT * FROM Tdata WHERE Tdata.date BETWEEN ? AND ?]. AS MyTempTbl ON TUnit.[cs-username] = MyTempTbl.[cs-username]
WHERE (((MyTempTbl.[cs-username]) Is Null))
ORDER BY Tunit.[cs-username];

N this is the second one :

SELECT Sum(TData.[time-taken]) AS [Total Of Minutes Login]
FROM TData;


I'm Keep Studying.... please show the way...
Not Good in English

 

[SonOfEmidec1100]

Hi, its me again

The first query returns usernames where there is NO data for this username in TData - so there is nothing to sum by username. Can you clarify what you are trying to do with the second sql statement. It does not make logical sense to me to combine it with the first one.

 

[zaq888]

what i mean is like this :
from the temp table that is range from ? to ? date, i also would like to sum the colum time-taken which is in the group table TData also... How can i do that sir???

I'm Keep Studying.... please show the way...
Not Good in English

 

[SonOfEmidec1100]

To select the sum change the query to this

SELECT [cs-username], Sum(TData.[time-taken]) AS [Total Of Minutes Login]
FROM Tdata
GROUP BY [cs-username]
WHERE Tdata.date BETWEEN ? AND ?

By itself this gives meaningfull data - But as I said this will serve no purpose if joined with the first query as the rows you are extracting are those with NO rows in MyTemTbl.
If the WHERE (((MyTempTbl.[cs-username]) Is Null)) is true then [Total Of Minutes Login] will also be Null.