title: CROSS JOIN alternative
body: <p>I have a result set already but I am interested in alternative queries with the same result. What can be better or faster between them?</p>
  
  <pre><code>insert into [dbo].[Teams]  values(1,'First')
  insert into [dbo].[Teams]  values(2,'Second')
  insert into [dbo].[Teams]  values(3,'Third')
  insert into [dbo].[Teams]  values(4,'Fourth')
  insert into [dbo].[Teams]  values(5,'Fifth')
  
  CREATE TABLE [dbo].[Team_team] (
  [id1] [int] NOT NULL,
  [id2] [int] NOT NULL
  ) ON [PRIMARY]
  GO
  
  select * from teams;
  
  select t1.id,t2.id  from teams t2 cross join teams t1 
  </code></pre>