query not working

[carlton123]

I have two querys which I then put in another query but all the times dont come through correct one is from a nismatch query and the other is calculated of the same one time - 15 minutes. Each query works but not when they are in same query together

 

[JHB]

Then show the SQL string from both queries and also how they looks when they are in the same query.
And some sample data.

 

[carlton123]

Then show the SQL string from both queries and also how they looks when they are in the same query.
And some sample data.

no worries now as your other solution has solved the need for this