I have few selects from 2 tables of which I want to output horizontal (when running, the number of lines is same), how can I combine them to 1 select horizontally 

```
select  * from [Table1] 

select b.ID, count(*) from  [Table2] b
left  join [Table1] a on a.ID=b.ID  
group by b.ID

```

Thanks in advance for the answer

[![enter image description here](https://i.stack.imgur.com/PxRHz.png)](https://i.stack.imgur.com/PxRHz.png)