Query with multiple tables

[danfergarc]

Hi!

On the sql management studio I execute this query using the table transactions and till.

select till.code,t.trans_date

from TCPOS4.dbo.transactions as t, TCPOS4.dbo.tills as till

where t.trans_date = (select max(t2.trans_date)

                      from TCPOS4.dbo.transactions as t2

                   where t2.till_id=t.till_id

                     ) and t.till_id=till.id order by trans_date desc;

 

The result are two columns. I just want to insert this query and inser the result on another table.