title: join tables without common field in sqlserver one in veritcal and other in horizontal
body: <p>I have 2 tables one is accounts where users user stored his multiple accounts and other is reports table where we have stored the number of reports but there is no link between them.</p>
  
  <pre><code>table 1 (accounts)
  
  accountid | contactId | accountname
  121           12        personal
  122           12        official
  
  table 2 (Reports)
  
  Reportid | ReportName
   1          bankstatment
   2          panreport
   3          other report
  </code></pre>
  
  <p>Now I want this output</p>
  
  <pre><code>account | contactid| reportid | reportname   | ReportId | ReportName   | ReportId | ReportName
  
  121       12           1       bankstatment    2          panreport       3          other report
  122       12           1       bankstatment    2          panreport       3          other report
  </code></pre>
  
  <p>How I can make it in SQL Server query ? I am asking this because I am not able to identify which account has selected which report in mvc.net in grid form  </p>