select with multiple occurences in same table

<div class="Section1"><p class="MsoNormal"><span class="EmailStyle15"><font color="black" face="Arial" size="2"><span
style="font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
Arial"><span style="mso-spacerun: yes">      </span>Table "inventorytrack"</span></font></span><p
class="MsoNormal"><spanclass="EmailStyle15"><font color="black" face="Arial" size="2"><span
style="font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
Arial"><span style="mso-spacerun: yes"> </span>Attribute<span style="mso-spacerun: yes">  </span>|<span
style="mso-spacerun:
yes">   </span>Type<span style="mso-spacerun: yes">    </span>| Modifier</span></font></span><p class="MsoNormal"><span
class="EmailStyle15"><fontcolor="black" face="Arial" size="2"><span
style="font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
Arial">------------+-----------+----------</span></font></span><p class="MsoNormal"><span class="EmailStyle15"><font
color="black"face="Arial" size="2"><span style="font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family: 
Arial"><span style="mso-spacerun: yes"> </span>tattoo<span style="mso-spacerun: yes">     </span>| text<span
style="mso-spacerun:yes">      </span>|</span></font></span><p class="MsoNormal"><span class="EmailStyle15"><font
color="black"face="Arial" size="2"><span style="font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family: 
Arial"><span style="mso-spacerun: yes"> </span>past_group | text<span style="mso-spacerun: yes">     
</span>|</span></font></span><pclass="MsoNormal"><span class="EmailStyle15"><font color="black" face="Arial"
size="2"><spanstyle="font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family: 
Arial"><span style="mso-spacerun: yes"> </span>ranch<span style="mso-spacerun: yes">      </span>| text<span
style="mso-spacerun:yes">      </span>|</span></font></span><p class="MsoNormal"><span class="EmailStyle15"><font
color="black"face="Arial" size="2"><span style="font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family: 
Arial"><span style="mso-spacerun: yes"> </span>ent_date<span style="mso-spacerun: yes">   </span>| timestamp
|</span></font></span><pclass="MsoNormal"><span class="EmailStyle15"><font color="black" face="Arial" size="2"><span
style="font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
Arial"><span style="mso-spacerun: yes"> </span>indate<span style="mso-spacerun: yes">     </span>| date<span
style="mso-spacerun:yes">      </span>|</span></font></span><p class="MsoNormal"><span class="EmailStyle15"><font
color="black"face="Arial" size="2"><span style="font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family: 
Arial"> </span></font></span><p class="MsoNormal"><span class="EmailStyle15"><font color="black" face="Arial"
size="2"><spanstyle="font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family: 
Arial"> </span></font></span><p class="MsoNormal"><span class="EmailStyle15"><font color="black" face="Arial"
size="2"><spanstyle="font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family: 
Arial">In the above table, I have multiple occurrences of ‘tattoo’.<span style="mso-spacerun: yes">  </span>However,
someof the tattoo’s have null value in ‘indate’, some do not.<span style="mso-spacerun: yes">  </span>I would like to
selectthose tattoos with a null indate, unless there is another identical tattoo in the table that has<span
style="mso-spacerun:yes">  </span>a date value in <span style="mso-spacerun: yes"> </span>‘indate’.<span
style="mso-spacerun:yes">  </span>For example, I might have:</span></font></span><p class="MsoNormal"><span
class="EmailStyle15"><fontcolor="black" face="Arial" size="2"><span
style="font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
Arial"> </span></font></span><p class="MsoNormal"><span class="EmailStyle15"><font color="black" face="Arial"
size="2"><spanstyle="font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family: 
Arial">tattoo |<span style="mso-spacerun: yes">   </span>past_group<span style="mso-spacerun: yes">   </span>|
ranch<spanstyle="mso-spacerun: yes">  </span>|<span style="mso-spacerun: 
yes">        </span>ent_date<span style="mso-spacerun: yes">        </span>|<span style="mso-spacerun: yes">  
</span>indate</span></font></span><pclass="MsoNormal"><span class="EmailStyle15"><font color="black" face="Arial"
size="2"><spanstyle="font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family: 
Arial">--------+----------------+--------+------------------------+------------</span></font></span><p
class="MsoNormal"><spanclass="EmailStyle15"><font color="black" face="Arial" size="2"><span
style="font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
Arial"><span style="mso-spacerun: yes"> </span>1039<span style="mso-spacerun: yes">   </span>| Barn2/Behind<span
style="mso-spacerun:yes">   </span>| Iberia | 2000-03-16 11:03:32-08 |</span></font></span><p class="MsoNormal"><span
class="EmailStyle15"><fontcolor="black" face="Arial" size="2"><span
style="font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
Arial"><span style="mso-spacerun: yes"> </span>1039<span style="mso-spacerun: yes">   </span>| Across/Bubs<span
style="mso-spacerun:yes">    </span>| Iberia | 2000-12-28 14:57:13-08 | 2000-12-28</span></font></span><p
class="MsoNormal"><spanclass="EmailStyle15"><font color="black" face="Arial" size="2"><span
style="font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
Arial"><span style="mso-spacerun: yes"> </span>1832<span style="mso-spacerun: yes">   </span>| GardnerBlock#3 | Iberia
|2000-03-16 11:03:32-08 |</span></font></span><p class="MsoNormal"
style="margin-left:33.6pt;text-indent:-30.6pt;mso-list:l0level1 lfo2; 
tab-stops:list 33.6pt"><span class="EmailStyle15"><font color="black" face="Arial" size="2"><span
style="font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial">1832<font face="Times New Roman" size="1"><span style="font:7.0pt "Times New Roman"">    
</span></font></span></font></span><spanclass="EmailStyle15"><font color="black" face="Arial" size="2"><span
style="font-size:
10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial">| GardnerBlock#2 | Iberia | 2000-12-28 12:46:57-08 | 2000-12-28
</span></font></span><pclass="MsoNormal" style="margin-left:33.6pt;text-indent:-30.6pt;mso-list:l0 level1 lfo2; 
tab-stops:list 33.6pt"><span class="EmailStyle15"><font color="black" face="Arial" size="2"><span
style="font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial">1833<font face="Times New Roman" size="1"><span style="font:7.0pt "Times New Roman"">    
</span></font></span></font></span><spanclass="EmailStyle15"><font color="black" face="Arial" size="2"><span
style="font-size:
10.0pt;mso-bidi-font-size:12.0pt;font-family:Arial">| Becker1<span style="mso-spacerun:
yes">            </span>| Iberia | 2000-03-16 11:03:32-08 |</span></font></span><p class="MsoNormal"
style="margin-left:3.0pt"><spanclass="EmailStyle15"><font color="black" face="Arial" size="2"><span
style="font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial"> </span></font></span><p class="MsoNormal"><span class="EmailStyle15"><font color="black"
face="Arial"size="2"><span style="font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family: 
Arial"> </span></font></span><p class="MsoNormal"><span class="EmailStyle15"><font color="black" face="Arial"
size="2"><spanstyle="font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family: 
Arial"> </span></font></span><p class="MsoNormal"><span class="EmailStyle15"><font color="black" face="Arial"
size="2"><spanstyle="font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family: 
Arial"> </span></font></span><p class="MsoNormal"><span class="EmailStyle15"><font color="black" face="Arial"
size="2"><spanstyle="font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family: 
Arial">So the prospective SELECT would give back:</span></font></span><p class="MsoNormal"><span
class="EmailStyle15"><fontcolor="black" face="Arial" size="2"><span
style="font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
Arial"> </span></font></span><p class="MsoNormal"><span class="EmailStyle15"><font color="black" face="Arial"
size="2"><spanstyle="font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family: 
Arial">tattoo |<span style="mso-spacerun: yes">   </span>past_group<span style="mso-spacerun: yes">   </span>|
ranch<spanstyle="mso-spacerun: yes">  </span>|<span style="mso-spacerun: 
yes">        </span>ent_date<span style="mso-spacerun: yes">        </span>|<span style="mso-spacerun: yes">  
</span>indate</span></font></span><pclass="MsoNormal"><span class="EmailStyle15"><font color="black" face="Arial"
size="2"><spanstyle="font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family: 
Arial">1039<span style="mso-spacerun: yes">   </span>| Across/Bubs<span style="mso-spacerun: yes">    </span>| Iberia |
2000-12-2814:57:13-08 | 2000-12-28</span></font></span><p class="MsoNormal"><span class="EmailStyle15"><font
color="black"face="Arial" size="2"><span style="font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family: 
Arial">1832| GardnerBlock#2 | Iberia | 2000-12-28 12:46:57-08 | 2000-12-28</span></font></span><p class="MsoNormal"
style="margin-left:3.0pt"><spanclass="EmailStyle15"><font color="black" face="Arial" size="2"><span
style="font-size:10.0pt;mso-bidi-font-size:
12.0pt;font-family:Arial">1833| Becker1<span style="mso-spacerun:
yes">            </span>| Iberia | 2000-03-16 11:03:32-08 |</span></font></span><p class="MsoNormal"><span
class="EmailStyle15"><fontcolor="black" face="Arial" size="2"><span
style="font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family:
Arial"> </span></font></span><p class="MsoNormal"><span class="EmailStyle15"><font color="black" face="Arial"
size="2"><spanstyle="font-size:10.0pt;mso-bidi-font-size:12.0pt;font-family: 
Arial">Any suggestions on how to do this?</span></font></span></div>