Join static query with query result

Question

question

monapatel728 asked Sep 18, '21

Good morning,

How can I join static query with the query result. If I want to join 2 queries result as one table with time as common column. How can I do this?

thanks in advance.

sql2008

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2021-09-20T07:19:52Z

anthony.green answered Sep 20, '21

Use nested sub queries.

Select *
from
(
My first select query
) as q1
Inner join
(
My second select query
) q2
ON q1.datetime = q2.datetime

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.