Inner Join one Column multiple search Query
<p>I know how to do a basic Inner Join query. However because of my data structure I need to get values from multiple tables in order to get the results I need. As of now in order for me to find an offense record I have to pass this query</p>

<pre><code>SELECT * FROM OFFENSE  where TRS_IDN IN 
(SELECT TRS_IDN FROM CCH_PUBLIC.dbo.TRS where TRN_IDN IN 
(select TRN_IDN from CCH_PUBLIC.dbo.TRN where IND_IDN = 
(SELECT TOP 1 IND_IDN FROM CCH_PUBLIC.dbo.PERSON WHERE PER_IDN = @PER_IDN)))
</code></pre>

<p>This results in this:</p>

<pre><code>OFF_IDN     TRS_IDN     AGY_TXT     DOO_DTE     AON_COD     AOL_TXT                 LDA_COD GOC_COD  ADN_COD     ADD_TXT     ADA_DTE     REF_TXT     IPN_NBR     ICA_NBR     DMV_COD

23808207    26154505    TX2270000   5/13/2013   54040014    DRIVING WHILE INTOXI    MA               205                     5/14/2013  TX227013A                1320573    
</code></pre>

<p>In the <code>CCH_PUBLIC.dbo.TRN</code> table there is a column called <code>TRN_IDN</code>. The objective is to inner join the <code>CCH_PUBLIC.dbo.OFFENSE</code> table with <code>CCH_PUBLIC.dbo.TRN</code> and add the SINGLE COLUMN called <code>TRN_IDN</code>. How can I do this</p>