title: How to compare entire row of a table with entire row of another table
body: <p>Is there a way in SQL Server to compare entire row of one table with another table which has same data types.</p>
  
  <p>Example:</p>
  
  <pre><code>CREATE TABLE [DBO].[PRODUCT]
    (
       [PID]  [INT] NULL,
       [NAME] [NCHAR](10) NULL,
       [PDID] [INT] NULL
    )
  </code></pre>
  
  <p><code>select * from product p, product c where p.{entirerow} = c.{entirerow}</code> </p>
  
  <p>is there some kind of option here?</p>